> -----Original Message----- > From: David Barron [mailto:[EMAIL PROTECTED] > Sent: 06 August 2004 17:10 > To: Mark Pittam; [EMAIL PROTECTED] > Subject: RE: Moving a database > > 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?
The dump file will contain all the create table statements and the insert statements to insert the data into the tables. You will need to create the database using the create database statement and then you can redirect the dump file into the mysql client. e.g. mysql -u root -p -D database_name < dumpfile Mark > > -----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]
