Hi,

Can anyone here give me your kindest advice on how to shift the whole MySQL database from one MySQL server to another MySQL server without the need of using third party software.

Thanks alot.

Warmest regards,
Keng Yiam

What about dumping and restoring the database? Here's a link for how to do so in the MySQL manual:

http://www.mysql.com/doc/en/mysqldump.html

There are other methods as well (direct transfer of the files from one server to another, replication), but they are dependent upon your version, which you don't mention.

Hope that helps.

Dennis Bennett

You can do it all in one shot on the commandline. I've used this method to copy an entire database from one server to another.

First, create an empty database on your target server. Then, pipe the dump output of your source database into the target host's database like so:

mysqldump -h<src_host> -u<src_user> -p<src_pass> -q <database> | mysql -h<targ_host> -u<targ_user> -p<targ_pass> <targ_database>


The -q options is the "quick" option, which means output is dumped immediately to stdout without being buffered in memory first. Generally speaking, you'll always want to use the -q option when dumping large amounts of data.



Take care,

Nik
http://www.bigaction.org/