Hi All, I performed the backup (mysqldump -u username -p db > backup.sql) of a database on a Win32 (4.0.15-max-debug) server in order to restore it on Linux server (4.0.15-9) When I try to restore it on the linux machine (with mysql -u username -p db < backup.sql), there is an error saying: ERROR 1064 at line 12748: 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 'Order tinyint(4) default NULL ) TYPE=MyISAM' at line 6
I searched the mailing list but nothing seems to apply to my case. The database has been created with the same name, cmsdb, which has no special characters Any help would be appreciated Gael first rows of backup file: -- MySQL dump 9.09 -- -- Host: localhost Database: cmsdb --------------------------------------------------------- -- Server version 4.0.15-max-debug -- -- Table structure for table `block` -- CREATE TABLE block ( BlockID int(11) NOT NULL auto_increment, PageID int(11) default NULL, BlockOrder int(11) default NULL, StyleID int(11) default NULL, BlockTypeID int(11) default NULL, PRIMARY KEY (BlockID) ) TYPE=MyISAM; -- -- Dumping data for table `block` -- INSERT INTO block VALUES (202176,8908,1,136,NULL); INSERT INTO block VALUES (201758,8890,2,150,NULL); INSERT INTO block VALUES (201757,8890,2,162,NULL); INSERT INTO block VALUES (201756,8890,1,162,NULL); INSERT INTO block VALUES (201755,8890,2,148,NULL); INSERT INTO block VALUES (201754,8890,1,110,NULL); INSERT INTO block VALUES (201753,8890,1,147,NULL); and then around row 12748: -- Table structure for table `contenttypeversion` -- CREATE TABLE contenttypeversion ( ContentTypeID int(11) default NULL, VersionID int(11) default NULL, Name varchar(100) default NULL, HTML_Label blob, Order tinyint(4) default NULL ) TYPE=MyISAM; --