Entry

how to move/copy huge MySql DB to another server? Thanx all

Feb 12th, 2008 04:27
dman, Narendra Jain, Sahar Zarrouk, http://sturly.com

The easiest way to copy / move it would be to use the mysqldump command
of mysql. Though, it should be noted that the exported script may need
some changes according to the database that you intend to inport to.
Some data types, data structures or some commands might be different on
other databases.
If you are transferring the data to another MySQL databse on a different
server moving the entire directory where the database is stored. For
your reference, the database is stored under '/var/lib/mysql'.