On Wed, 2003-10-29 at 14:18, Chris W. Parker wrote:
> Matt W <mailto:[EMAIL PROTECTED]>
> on Monday, October 27, 2003 5:29 PM said:
>
> > As to why mysqldump would "create a dump file with a syntax error in
> > it," that's because *you* (or the application creator) used a reserved
> > word for a column/index name (bad idea) and mysqldump
>
> I always try to be careful about this and I even compared all the column
> names in my db to the reserved word list on the MySQL site and didn't
> find any matches.
It may be best to always use the --quote-names option to mysqldump,
which would avoid any problems you might encounter with reserved words
being used in column and table names.
--
Andy Bakun: when uselessness just isn't enough
<[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
