[plug] moving mysql database

[James Devenish]

In message <se625c4c.013 at mmtnetworks.com.au>
on Sun, Mar 02, 2003 at 07:32:27PM +0800, Jon  Miller wrote:
> Does anyone know how to move a MySQL database from one server to
> another?  Any doco would be greatly appreciated.

If you have the same MySQL version on the same hardware, it is possible
to simply copy the files over (e.g. it's like making a backup).
Otherwise, an export/import process. A quick glance at the docs
(RTFM) revealed:

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#mysqldump
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#mysqlimport
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#Moving

Anecdotally, these things work as documented.