Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    United Kingdom
    Posts
    16

    Problem trying to restore mySQL

    I resently moved host to a new server. I backed up the sql and wish to restore it on my new server.

    I uploaded the .sql file to the root of my server, went into phpMy Admin and used the >mysql -u USERNAME -p DATABASE_NAME < backup.sql query but ti gave a syntax error.

    Any Suggestions?

  2. #2
    Join Date
    Jun 2002
    Location
    TO, Ontario, Canada
    Posts
    372
    Contact your host and ask them to use SSH to do a proper restore and stay away form phpMyAdmin

    Could be that they don't have a link to mysql so that you have to use the actual path...

    What is the syntax error message?
    Not sure if phpMyAdmin even allows console commands either

  3. #3
    Join Date
    Apr 2002
    Posts
    1,789
    I thought phpMyAdmin had its own restore function? You gave it the path to your MySQL dump file on your local computer, and it restored it. Might be wrong.

    You might try giving the full path to your dump file on the server, and running it through phpMyAdmin.

    You could always log into the shell and use:

    mysql -u 'user' -p 'database_name' < file.sql

    And enter your password when prompted.

Posting Permissions

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