1) Both systems must be running MySQL (should not be stopped)
2) On target system, first create the empty database (I used MyPHP to create database).
3) Ran the following command (of course replaced the parameters like SOURCE-USERNAME etc to actual username.
# mysqldump -hlocalhost -u[source-user] -p[source-pwd] DB-NAME | mysql -h[dest-host] -u[dest-user] -p[dest-pwd] DEST-DBNote: This method was tried on a Redhat Linux 6.x system and worked perfectly!!! :)
No comments:
Post a Comment