moving mysql from one server to another

[PaullasPaullas is verified member.]

hi all.

hope someone can guide me on this.

I have a few mysql databases on a windows web edition server and need to move then to a server 2003 server.

can anyone give an idiots giude on moving them.

thanks in advance.

 

[AdminAdmin is verified member.]

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.