How does mysqldbcopy function
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.


are you sure @LIVE:REPORT is correct?
LIVE:REPORT try remove @
try --drop-first ( old way was --force &lt; 1.4.2 )


So:

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.



After thinking I may tweak script a little.

0 12 * * * mysqldbcopy --source=user:pass@host:port:socket --destination=user:pass@host:port:socket orig_db:new_db --drop-first



I will most likely make cred.cnf file to call with credentials for both source and destination.  


cred.cnf file like this (mine hidden and locked down)...

[source]
port=3306
user=user
password=secret
host=pathtodb

[destination]
port=3306
user=user
password=secret
host=pathtodb


This is how my testing cron job will look...

0 12 * * * mysqldbcopy --source=/path/to/cred.cnf[source] --destination=/path/to/cred.cnf[destination] orig_db:new_db --drop-first


good luck.  I will follow-up when I get time to test my system and confirm this works or not.