Web Hosting Talk







View Full Version : Restore MySQL db...


homeiss
11-10-2002, 12:52 AM
I am moving a SQL db from one server to another and I have the SQL file, I tried phpMyAdmin but it didn't work and the file is 33.7MB so how would you recomend and please explain how to do it as well.

Thanks

Ratty
11-10-2002, 01:38 AM
I would do it all from the command line.

Ftp the file to your new server and then import it into the new database with the following

[path to mysql bin dir]/mysql -u [db user name] -p [db name] < dbdump.sql

You will be promoted for your db password. Enter the password, the file will be imported and your all done.