>Description:
When dumping the 'mysql' database, the dump file contains syntax errors,
and I can't find where this has been rectified in later releases.
Example dump using 'mysqldump -cl mysql':
[snip]#
# Table structure for table 'db'
#
CREATE TABLE db (
Host char(60) NOT NULL default '',
Db char(32) NOT NULL default '',
User char(16) NOT NULL default '',
Select_priv enum('N','Y') NOT NULL default 'N',
Insert_priv enum('N','Y') NOT NULL default 'N',
Update_priv enum('N','Y') NOT NULL default 'N',
Delete_priv enum('N','Y') NOT NULL default 'N',
Create_priv enum('N','Y') NOT NULL default 'N',
Drop_priv enum('N','Y') NOT NULL default 'N',
Grant_priv enum('N','Y') NOT NULL default 'N',
References_priv enum('N','Y') NOT NULL default 'N',
Index_priv enum('N','Y') NOT NULL default 'N',
Alter_priv enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (Host,Db,User),
KEY User(User)
) TYPE=MyISAM;
[/snip]
Trying to re-load this table fails with the following error message:
ERROR 1064: You have an error in your SQL syntax near 'User(User)
) TYPE=MyISAM' at line 16
Hopefully I'm not just re-iterating a previously fixed problem. Feel
free to email me if more information is needed.
>How-To-Repeat:
Dumping the mysql database is enough to re-create this problem. (Checked in both
3.23.33 and 3.23.32.)
>Fix:
Changing
KEY User(User)
To
KEY User (User)
In the dump fixes this.
>Submitter-Id: None
>Originator:Tony Wells
>Organization:
None
>MySQL support: none
>Synopsis: mysqldump of mysql database has syntax error in SQL
>Severity: non-critical
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.33 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.15 Distrib 3.23.33, for -freebsd4.2 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.33
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 3 min 37 sec
Threads: 1 Questions: 195 Slow queries: 0 Opens: 64 Flush tables: 1 Open tables:
58 Queries per second avg: 0.899
>Environment:
System: FreeBSD camel.kdsi.net 4.5-STABLE FreeBSD 4.5-STABLE #0: Wed Apr 24 10:19:40
CDT 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/IPFW i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe' CXX='c++' CXXFLAGS='-O -pipe
-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1221930 Apr 24 11:25 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Apr 24 11:25 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 579224 Apr 24 11:25 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl
--without-debug --without-readline --without-bench --with-mit-threads=no
--with-libwrap --with-low-memory --enable-assembler --prefix=/usr/local
i386--freebsd4.2
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
