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]