Mysql Resotre Error [create-options]

[clbbhk]

i got so many file to restore....after reinstalled the os
how to solve this problems once?
also , i can't edit so large file , as some sql are larger than 2GB.

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

 

[zEitEr]

There's nothing about size of your SQL file. Does this error occur only when you restore from big dumps? Did you try do it manually?

 

[clbbhk]

it is a bug cause by the directadmin and the MySQL 5.5, it seems fixed now.
BUT!!! the old backup created under this bug .....can not be restore...

 

[zEitEr]

Perhaps, The big files are corrupted. Try un-pack them and restore MySQL data manually.

 

[clbbhk]

Perhaps, The big files are corrupted. Try un-pack them and restore MySQL data manually.

i need to edit each sql file and restore again, because one error message was added to each sql file when backup....