Is it possible to move my mysql database to another server

Hi,

Can any one tell me how to move my mysql database to another server

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.