30 2 * * * mysqldbcopy --source=user:pwd@localhost --destination=user:pwd@LIVE:REPORT
I want to do the same thing and about to test for myself in next week or so. 1) are you sure @LIVE:REPORT is correct? LIVE:REPORT try remove @ 2) try --drop-first ( old way was --force < 1.4.2 )
30 2 * * * mysqldbcopy --source=user:pwd@localhost --destination=user:pwd LIVE:REPORT --drop-first
This is what I am going to test. I am admittedly a noob - fair warning.
