[Lolli]

Originally Posted by Marco van Herwaarden

If you have a recent backup i would start by restoring it.

Hi Marco, thanks very much for your reply.

I tried to restore the database, but I get the following error:

ERROR 1064 (42000) at line 1: 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

The database backup is performed by the script vb_backup.sh of vB 3.8.4, and the restore with SSH and the command 'mysql':

dbusername mysql -u root -p databasename < backupname.sql

We have this MySQL server:

Server version: 5.1.45 MySQL Community Server (GPL)

Any ideas?

--------------- Added [DATE]1275782688[/DATE] at [TIME]1275782688[/TIME] ---------------

Okay, to make usable the backup I had to remove the first line, which consisted of a warning:

Warning: The option '--all' is deprecated and will be removed in a future releas

It is probably added by mysqldump at the time to create the file .sql

Alright, thanks.