Tony,
Friday, April 26, 2002, 12:15:00 AM, you wrote:
TW>Description:
TW> When dumping the 'mysql' database, the dump file contains syntax errors,
TW> and I can't find where this has been rectified in later releases.
TW> Example dump using 'mysqldump -cl mysql':
TW> [snip]#
TW> # Table structure for table 'db'
TW> #
TW> CREATE TABLE db (
TW> Host char(60) NOT NULL default '',
TW> Db char(32) NOT NULL default '',
TW> User char(16) NOT NULL default '',
TW> Select_priv enum('N','Y') NOT NULL default 'N',
TW> Insert_priv enum('N','Y') NOT NULL default 'N',
TW> Update_priv enum('N','Y') NOT NULL default 'N',
TW> Delete_priv enum('N','Y') NOT NULL default 'N',
TW> Create_priv enum('N','Y') NOT NULL default 'N',
TW> Drop_priv enum('N','Y') NOT NULL default 'N',
TW> Grant_priv enum('N','Y') NOT NULL default 'N',
TW> References_priv enum('N','Y') NOT NULL default 'N',
TW> Index_priv enum('N','Y') NOT NULL default 'N',
TW> Alter_priv enum('N','Y') NOT NULL default 'N',
TW> PRIMARY KEY (Host,Db,User),
TW> KEY User(User)
TW> ) TYPE=MyISAM;
TW> [/snip]
TW> Trying to re-load this table fails with the following error message:
TW> ERROR 1064: You have an error in your SQL syntax near 'User(User)
TW> ) TYPE=MyISAM' at line 16
TW> Hopefully I'm not just re-iterating a previously fixed problem. Feel
TW> free to email me if more information is needed.
TW>How-To-Repeat:
TW> Dumping the mysql database is enough to re-create this problem. (Checked in both
TW> 3.23.33 and 3.23.32.)
TW>Fix:
TW> Changing
TW> KEY User(User)
TW> To
TW> KEY User (User)
TW> In the dump fixes this.
TW>Submitter-Id: None
TW>Originator:Tony Wells
TW>Organization:
TW> None
TW>MySQL support: none
TW>Synopsis: mysqldump of mysql database has syntax error in SQL
TW>Release: mysql-3.23.33 (Source distribution)
TW>Server: /usr/local/bin/mysqladmin Ver 8.15 Distrib 3.23.33, for -freebsd4.2 on i386
There is a function "user()". So, it's a cause of the problem.
If you start mysql with --sql-mode=IGNORE_SPACES it will behave the same.
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.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
