How do I recreate the database on the new server? Do I have to recreate each table again or will the dump file contain that information?
> -----Original Message----- > From: Mark Pittam [mailto:[EMAIL PROTECTED] > Sent: Friday, August 06, 2004 12:06 PM > To: David Barron; [EMAIL PROTECTED] > Subject: RE: Moving a database > > > -----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]