From: Brian Mansell (lifeofbriangmail.com)
Date: Mon Mar 26 2007 - 12:47:56 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

The 'group' column needs to be quoted (use --quote-names with mysqldump).

cheers,
--bemansell

On 3/26/07, Rob Tanner <rtannerlinfield.edu> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]