>Description:
Performing a "mysqldump --all-databases --opt" produces invalid
SQL for the "db" table i.e.:
KEY User(User)
Attempting to rebuild tables with the mysql client using this SQL fails
with a syntax error.
If the SQL is modified to:
KEY User (User)
then the mysql client creates the "db" table happily.
>How-To-Repeat:
mysqldump --all-databases --opt > foo.sql
mysql < foo.sql
>Fix:
Ensure a space character seperates the KEY name and parenthesis.
>Submitter-Id: <submitter ID>
>Originator: Neil Darlow
>Organization:
>MySQL support: none
>Synopsis: mysqdump generates invalid SQL for "db" table
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for unknown-openbsd2.7
>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.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/mysql/mysql.sock
Uptime: 4 days 1 hour 40 min 12 sec
Threads: 7 Questions: 878 Slow queries: 1 Opens: 180 Flush tables: 1 Open tables:
12 Queries per second avg: 0.002
>Environment:
System: OpenBSD kandb 2.7 KANDB#0 i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-unknown-openbsd2.7/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc' CFLAGS='-O2 ' CXX='c++' CXXFLAGS='-O2 '
LDFLAGS='-L/usr/local/lib'
LIBC:
-r--r--r-- 1 root bin 687102 Dec 11 19:34 /usr/lib/libc.a
-r--r--r-- 1 root bin 563475 Dec 11 19:34 /usr/lib/libc.so.25.0
Configure command: ./configure --enable-shared --enable-static
--localstatedir=/var/mysql --with-libwrap --with-mysqld-user=mysql
--with-unix-socket-path=/var/mysql/mysql.sock --without-perl --without-debug
--without-readline --without-bench --without-mit-threads --prefix=/usr/local
--sysconfdir=/etc
---------------------------------------------------------------------
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
