Restoring Mysql Databases

davethegenius · 08-05-2005, 12:10 PM

Hey guys and gals,

I currently run an apache server with mysql on windows and am ready to move to a real operating system. I have everything ready to go but need to restore all my mysql databases through the one rolled up file. So there is a file called backup.sql and want to restore all the databases into the server. Thanks alot

Dave

comprookie2000 · 08-05-2005, 01:35 PM

I use phpmyadmin;
http://www.sonnexh.com/forums/showthread.php?t=205

apolinsky · 08-05-2005, 02:01 PM

There is a utility called mysqldump. It not only produces a schema, it will include all the data from the database. The syntax is mysqldump [options] databasename > somename. the somename file will contain everythin needed to produce the database. you would then go to the new box and give the command mysql < somename. There are many options you can use. Take a look at man.