Results 1 to 3 of 3
Thread: Problem trying to restore mySQL
-
01-14-2003, 01:44 PM #1Newbie
- 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?
-
01-14-2003, 01:49 PM #2Aspiring Evangelist
- 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
-
01-14-2003, 03:44 PM #3Web Hosting Master
- 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.