List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:February 25 2000 5:54pm
Subject:Spaces in key names and key elements not quoted by mysqldump
View as plain text  
>>>>> "ews" == ews  <ews@stripped> writes:

>> Description:
ews> 	mysqldump is creating a file that can't be read back into
ews> 	mysql. Seems it's not quoting the IDs in UNIQUE KEYs when
ews> 	they contain spaces.

>> How-To-Repeat:


ews> # mysql foo
ews> create table foo (
ews> 	`a b` VARCHAR(42),
ews> 	UNIQUE KEY (`a b`)
ews> );

ews> # mysqldump foo > /tmp/foo.out

ews> # MySQL dump 7.2
ews> #
ews> # Host: localhost    Database: foo
ews> #--------------------------------------------------------
ews> # Server version	3.23.11-alpha-log

ews> #
ews> # Table structure for table 'foo'
ews> #
ews> CREATE TABLE foo (
ews>   `a b` varchar(42),
ews>   UNIQUE a b (a b)
ews> );

Hi!

I have now fixed this for MySQL 3.23.12

Regards,
Monty
Thread
Spaces in key names and key elements not quoted by mysqldumpews24 Feb
  • Spaces in key names and key elements not quoted by mysqldumpMichael Widenius26 Feb