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
Thanks
![]() | 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. |