In the last episode (Feb 07), Kevin S. Brackett said:
> mysqldump: Got error: 1064: You have an error in your SQL syntax near
> 'index READ /*!32311 LOCAL */,sites READ /*!32311 LOCAL */,welcome READ
> /*!32311 ' at line 1 when using LOCK TABLES
index is a reserved word. Not sure how you managed
I hate to reply my own emails, but the fix was adding --quote-names to the
mysqldump options.
- kevin
On Fri, 7 Feb 2003, Kevin S. Brackett wrote:
> mysqldump: Got error: 1064: You have an error in your SQL syntax near
> 'index READ /*!32311 LOCAL */,sites READ /*!32311 LOCAL */,welcome READ
> /
mysqldump: Got error: 1064: You have an error in your SQL syntax near
'index READ /*!32311 LOCAL */,sites READ /*!32311 LOCAL */,welcome READ
/*!32311 ' at line 1 when using LOCK TABLES
anyone know what is causing this, and more imporantly how to fix it?
Thanks
- kevin
PS, please cc me as i'm not
