Copying your MySQL databases from the command line, if you have privileges is easy, a lot easier than going into PHP MyAdmin and hoping the “Copy Database” function is available and it doesn’t time out…
Here’s how you can copy databases to a remote server:
1 2 3 4 5 | mysqldump your_db_name | ssh host2 "mysql your_db_copy" |
Here how you copy MySQL database to a local server:
1 2 3 4 5 | mysqldump your_db_name | mysql your_db_copy |
