Use --allow-keywords option with mysqldump command
Anil
-Original Message-
From: Brian Mansell [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 11:18 PM
To: Rob Tanner
Cc: mysql@lists.mysql.com
Subject: Re: Getting SQL errors porting databases between MySQL v4 and v5
The 'group' column needs to be quoted (use --quote-names with mysqldump).
cheers,
--bemansell
On 3/26/07, Rob Tanner [EMAIL PROTECTED] wrote:
Hi,
I am porting over 6 databases from a MySQL v4 installation to a MySQL v5
installation and getting an SQL error in the process.
I am using the following command to dump the data in the v4 installation:
mysqldump -u root --password=secret --add-drop-table --databases db1
db2
db3 db4 db5 db6 db.sql
and using the following command to upload the databases on to the v5
installation:
mysql -u root -p db.sql
But then I get this error:
ERROR 1064 (42000) at line 140784: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right
syntax to use near 'group varchar(5) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM' at line 8
The whole create table sequence from the db.sql file is:
DROP TABLE IF EXISTS admission_quotes;
CREATE TABLE admission_quotes (
id int(4) NOT NULL auto_increment,
quote text,
author text,
category text,
class text,
active text,
group varchar(5) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
Any idea what the issue is? Is there something special I need to do when
porting the databases between MySQL v4 and v5?
Thanks,
Rob
--
Rob Tanner
UNIX Services Manager
Linfield College, McMinnville OR
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]