Lynn David Newton wrote:
It's the first KEY definition it doesn't like. If II had one like this yesterday.
comment out "KEY field(field)," it works, except of
course then the field called 'field' is not set as an
index. The same exact problem occurs in two places in
the mysqldump file. With them commented out the DB
reloads.
I'm pretty sure 'field' is a reserved word.
The problem arises because some GUIs back-quote (`) all field / index names, which MySQL then can recognize as names.
My feeling is that MySQL shouldn't allow reserved words / characters like this, whether they are in quotes or not.
You can continue to use KEY field(field) if you must by using the -Q option with mysqldump, to quote fieldnames.
But I wouldn't.
Does anyone know the logic behind allowing reserved words when inside quotes like this? It clearly causes problems - especially for people using GUIs - and these people will be the least able to diagnose the problem.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php