On Thu, 22 Feb 2001, Sinisa Milivojevic wrote:
> Matt Loschert writes:
> > On Thu, 22 Feb 2001, Sinisa Milivojevic wrote:
> >
> > > [EMAIL PROTECTED] writes:
> > > > >Description:
> > > >
> > > > As of mysql 3.23.33, a dumpfile generated with mysqldump (using the
>flags:
> > > > --opt --all-databases) creates a file which will not be uploaded
>correctly
> > > > using the mysql client (as in: 'mysql -u root -pXXXXXX -q -s <
>dumpfile.sql').
> > > >
> > > > Specifically, the problem relates to mysqldump's outputting of table
>keys.
> > > > See the actual dump of mysql.db below:
> > > >
> > > > DROP TABLE IF EXISTS db;
> > > > CREATE TABLE db (
> > > > Host char(60) binary NOT NULL default '',
> > > > Db char(64) binary NOT NULL default '',
> > > > User char(16) binary 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) <---- pukes on this line
> > > > ) TYPE=MyISAM COMMENT='Database privileges';
> > > >
> > > > If a space is added (as in: "KEY User (User)"), the file will import
>correctly.
> > > >
> > > > I looked through the source file mysqldump.c and it appears that there
>always
> > > > should be a space between the key name and the key columns, but my
>personal
> > > > dumpfiles show that all non-primary keys have no space between the key
>name
> > > > and the key column names. Go figure. :) Needless to say I don't get
>it.
> > > >
> > > > >How-To-Repeat:
> > > > See above description.
> > > > >Fix:
> > > > See above description.
> > > >
> > > > >Submitter-Id: <submitter ID>
> > > > >Originator: Matt Loschert
> > > > >Organization:
> > > >
> > > > Matt Loschert | email: [EMAIL PROTECTED]
> |
> > > > Software Engineer | web: http://www.servint.net/ |
> > > > ServInt Internet Services | phone: (703) 847-1381 |
> > > >
> > > > >
> > > > >MySQL support: none
> > > > >Synopsis: mysqldump output file not valid as input file for mysql client
> > > > >Severity: non-critical
> > > > >Priority: medium
> > > > >Category: mysql
> > > > >Class: sw-bug
> > > > >Release: mysql-3.23.33 (Source distribution)
> > > >
> > > > >Environment:
> > > >
> > > > System: FreeBSD delft.servint.com 4.2-STABLE FreeBSD 4.2-STABLE #0: Tue Feb
>6 11:43:35 EST 2001
>[EMAIL PROTECTED]:/disk2/cvsup/branches/releng_4/obj/disk2/cvsup/branches/releng_4/src/sys/QUICKIE
> 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.2 19991024 (release)
> > > > Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> > > > LIBC:
> > > > -r--r--r-- 1 root wheel 1169450 Feb 6 12:05 /usr/lib/libc.a
> > > > lrwxr-xr-x 1 root wheel 9 Feb 6 12:05 /usr/lib/libc.so -> libc.so.4
> > > > -r--r--r-- 1 root wheel 559516 Feb 6 12:05 /usr/lib/libc.so.4
> > > > Configure command: ./configure --prefix=/usr/local/mysql-23.33
>--with-low-memory
> > > > Perl: This is perl, version 5.005_03 built for i386-freebsd
> > > >
> > >
> > >
> > > Hi!
> > >
> > > The above happens as USER is a keyword in MySQL.
> > >
> > >
> > > Regards,
> > >
> > > Sinisa
> >
> > Sure, but this is a standard dump of the whole database, and the mysql
> > client is having problems reloading the **mysql** database. The mysql.db
> > table defines this key, not one of my tables. If you cannot use the
> > --all-databases flag to mysqldump to make a valid backup file, what is the
> > flag useful for? :)
> >
> > By the way, this used to work. I am not sure exactly what release it
> > stopped working in.
> >
> > Thanks for the help.
> >
> > - Matt
> >
> > --
> > Matt Loschert | email: [EMAIL PROTECTED] |
> > Software Engineer | web: http://www.servint.net/ |
> > ServInt Internet Services | phone: (703) 847-1381 |
> >
> >
> >
>
>
> It is not client bug, but a server bug.
>
> We shall put on our TODO to fix that.
>
>
> Regards,
>
> Sinisa
Thanks, I appreciate the help.
- Matt
--
Matt Loschert | email: [EMAIL PROTECTED] |
Software Engineer | web: http://www.servint.net/ |
ServInt Internet Services | phone: (703) 847-1381 |
---------------------------------------------------------------------
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
