mysqldump error: 1064

[yoannnesme]

I got this error when trying to backup my database:

[root@server bkp]# mysqldump -u admin -p --opt --all-databases > bkp20040429.sql
Enter password:
mysqldump: Got error: 1064: You have an error in your SQL syntax near 'add READ /*!32311 LOCAL */,conteudo READ /*!32311 LOCAL */,ir_user READ /*!32311' at line 1 when using LOCK TABLES

Any suggestions?:confused:

[Floris]

Run optimize & repair on your tables and try again.

[yoannnesme]

Thank you.

I just added the -Q option, and it worked.