Guest Posted August 10, 2005 Share Posted August 10, 2005 I dumped my mysql database using mysqldump and when I try to restore the database back into mysql I get this error: ERROR 1064 at line 244: 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 'default int(1) NOT NULL default '0', KEY moduleId (moduleId) -- MySQL dump 9.11 -- -- Host: localhost Database: arond_localdb -- ------------------------------------------------------ -- Server version 4.0.24-standard I discovered the offending cubecart table entry which was: DROP TABLE IF EXISTS store1_CubeCart_Modules; CREATE TABLE store1_CubeCart_Modules ( moduleId int(11) NOT NULL auto_increment, module varchar(10) NOT NULL default '', folder varchar(30) NOT NULL default '', status smallint(1) NOT NULL default '0', default int(1) NOT NULL default '0', KEY moduleId (moduleId) ) TYPE=MyISAM; and the offending line is >> default int(1) NOT NULL default '0', changing the name from "default" to "default2" seems to fix this error but then more errors crop up later, has anyone had this problem and found a fix? Thank you, Aron Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.