DB restore error

N

nservices

Verified User
Joined
Dec 11, 2008
Messages
300
Hi,
am using MySQL Server version: 5.1.45
MySQL client version: 5.1.45
and i can't use the restore option from Directadmin panel
when i try to restore db from backup, i get the next error:
Unable to restore database user_dbname.sql to user_dbname : ERROR 1064 (42000) at line 1 in file: '/home/user/backups/backup/user_dbname.sql': 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 'Warning: The option '--all' is deprecated and will be removed in a future releas' at line 1
 
I've seen these before and are usually due to either:

--> hidden character in syntax (character set problem)
--> syntax not back-ticked
--> mysql version subtle differences
--> use of --opt when using mysqldump

Head over to the MySQL forums (http://forums.mysql.com), as this isn't likely to be related to DirectAdmin.
 
it not in phpmyadmin

it on the integrate backup and restore option
how i can change this configurations ?
 
There is already a current thread dealing with this. Please search the forum to find it. I would post it but I don't know it from memory.
 
You must log in or register to reply here.
Back
Top