Restore failure

[MtK]

Hey,
I have a hosted site on the admin account, and also a MySQL DB for it.
I made a USER backup, and when I tried to restore it, I got:

Unable to restore database admin_DBNAME.sql to admin_DBNAME : ERROR 1064 (42000) at line 1 in file: '/home/admin/backups/backup/admin_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

but if I take this SQL file and try to manually import it, it works fine...

 

[floyd]

There is a very long thread already about this issue. Search the forum and you will find it and the solution. The short answer is update DirectAdmin and create the backups again.