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
Matt,
Tuesday, February 26, 2002, 12:52:08 PM, you wrote:
MJ> New to list so please excuse me if this is an obvious question.
MJ> Is there any tools / documentation to simplify porting MS Access databases
MJ> to MySQL ?
MySQL-Front can help you.
You can download MySQL-Front and find info about t
This one gets answered about 6 times per month, so
perhaps the Mysql doc team could consider putting
an FAQ or heading in the documentation for it.
For example, under "A Problems and Common Errors",
which is not English, by the way, there should be
a heading "Porting, Importing, and Exporting".
New to list so please excuse me if this is an obvious question.
Is there any tools / documentation to simplify porting MS Access databases
to MySQL ?
This Internet E-mail is intended solely for the person to whom it is addre