> -----Original Message----- > From: David Barron [mailto:[EMAIL PROTECTED] > Sent: 06 August 2004 14:56 > To: [EMAIL PROTECTED] > Subject: Moving a database > > Good morning, > > What's the best way to move a database and all of its tables from one > server to another? > > Thanks
You can use the mysqldump utility to dump the database you want to move. Then use the dump file to recreate the database in the mysql instance running on your other server. If you are using myisam tables and are able to shutdown your servers you can copy all the files in the data/<database_name> directory into a directory of the same name in the data directory of your new server. Be sure to copy all the files (.MYD, .MYI, .frm) Regards Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
