Restore Problem

[benbow]

Hi, I have tried to restore a backup but i am getting timed out, i have put the code in the sql query box and it comes up with this,

 

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -hlocalhost -ufairytale-bridalwear_co_uk -p fairytale-brid

 

 

Can anyone point me in the right direction to this problem, any help would be appreciated.

[davidinottawa]

Hi, I have tried to restore a backup but i am getting timed out, i have put the code in the sql query box and it comes up with this,

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -hlocalhost -ufairytale-bridalwear_co_uk -p fairytale-brid

Can anyone point me in the right direction to this problem, any help would be appreciated.

 

In the past, I have uploaded my sql file to my server, and asked the tech support guys at my host to run the back up from the shell.

here is the syntax :

mysql -u [username] -p [password] [database_to_restore] < [backupfile]

 

I've never successfully restored through phpmyadmin and I don't have ssh on several of my domains.

Probably wouldn't have mysql rights even if I did!

[cmjennings21]

Hi, I have tried to restore a backup but i am getting timed out, i have put the code in the sql query box and it comes up with this,

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -hlocalhost -ufairytale-bridalwear_co_uk -p fairytale-brid

Can anyone point me in the right direction to this problem, any help would be appreciated.

Try downloading your admin/backup file to your local machine and save as a text file. Once you have this then you need to go to mysql and import the file, hop ethis helps