Posted in
Hosting & IIS7 |
No Comment | 2,623 views | 27/12/2011 09:43
If you need to move your MySQL database from one server to another, you can use the following codes.
Dump:
mysqldump -u root -pPASSWORD DatabaseName > dbbackup.sql |
mysqldump -u root -pPASSWORD DatabaseName > dbbackup.sql
Import:
mysql -u root -pPASSWORD DatabaseName < dbbackup.sql |
mysql -u root -pPASSWORD DatabaseName < dbbackup.sql
You can do this process live.