copy data from prod to test - when database name is not the same name

2007-02-23 Thread Brown, Charles
Hello All, We have two mysql environment PROD and TEST. I would like to copy data from PROD to TEST. The PROD database name is Mysql_prod and the TEST database name is mysql_TEST. Using mysqldump or any applicable utility can someone show me how to migrate my production data from prod to test.

Re: copy data from prod to test - when database name is not the same name

2007-02-23 Thread Rolando Edwards
:48:27 AM (GMT-0500) Auto-Detected Subject: copy data from prod to test - when database name is not the same name Hello All, We have two mysql environment PROD and TEST. I would like to copy data from PROD to TEST. The PROD database name is Mysql_prod and the TEST database name is mysql_TEST