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 is a reserved word, so MySQL thinks you're attempting a 'group
by' statement. Put backticks around group, you should always quote your
table and column names.
DROP TABLE IF EXISTS `admission_quotes`;
CREATE TABLE `admission_quotes` (
`id` int(4) NOT NULL auto_increment,
`quote` text,
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 th
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