Is it possible to move my mysql database to another server
By Arun Desai
Hi,
Can any one tell me how to move my mysql database to another server
Teacher SiliconIndia replied to Arun Desai Friday, November 27, 2009
Hi Arun,
Yes it is possible using two common know mysql utilities know as mysql and mysqldump you need access to those, if you dont have access to those you can use phpmyadmin or mysqlfront.
Here is what to do:
First you need to dump your database from the old server using mysqldump as follows from a prompt:
mysqldump -h host -u user -p database > dump_file
Second you need to import the sql and data to the database using mysql as follows from a prompt:
mysql -h host -u user -p database < dump_file
After that it should be transfered correctly.
