Results 1 to 2 of 2
  1. #1

    Restore MySQL db...

    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.

    Cory Cone

  2. #2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts