Why does Robocopy work once and then ignore all files the next time?

Question

Our mysql server has "SQL_NO_CACHE" off by default, and I wish it off for my application. I can rewrite all my SQL statements but it sound stupid.

According to the mysql docs the per connection default can be configure by the following command.

SET SESSION query_cache_type = OFF;

I wish this statement will be issues for each new connect created from by DataSource. However, I don't find it is a configurable properties in the connector/j JDBC driver.

DBCP's connectionInitSqls seem to be one of the option, but I am using 1.2.2 for some reason. And I may want to remove the dependency of DBCP (less is more).

Solution

I can only guess that the /MIR is assuming that the files are already there and not checking again. Maybe include the /FFT switch as well which uses timestamps for comparison and see if it makes a difference.

Alternatively let robocopy log what it is doing. The log file may reveal why it is currently skipping files or folders. I would use the following for troubleshooting:

Robocopy c:\source c:\backup /MIR /V /LOG:WhySkip.txt /XD .svn

Added:
/V - Verbose listing including skipped files
/LOG:file - Log output to file

Comments

[Snark]

I cannot reproduce this problem. If I delete the backup dir and run robocopy again, it will do the copy again.

[hjoelr]

Well I changed the target directory so that it works.