seintitus Posted May 20, 2013 Share Posted May 20, 2013 I am getting an error while trying to import database on mysql 5.5. Here is the error: Error SQL query:CREATE TABLE `dp_banks` (`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,`owner` INT( 11 ) NOT NULL DEFAULT '0',`bname` VARCHAR( 128 ) NOT NULL DEFAULT '',`baddress` VARCHAR( 128 ) NOT NULL DEFAULT '',`bcity` VARCHAR( 64 ) NOT NULL DEFAULT '',`bzip` VARCHAR( 16 ) NOT NULL DEFAULT '',`bcountry` CHAR( 2 ) NOT NULL DEFAULT '',`bstate` VARCHAR( 32 ) NOT NULL DEFAULT '',`bphone` VARCHAR( 32 ) NOT NULL DEFAULT '',`bnameacc` VARCHAR( 128 ) NOT NULL DEFAULT '',`baccount` VARCHAR( 32 ) NOT NULL DEFAULT '',`btype` CHAR( 2 ) NOT NULL DEFAULT '',`brtgnum` VARCHAR( 9 ) NOT NULL DEFAULT '',`bswift` VARCHAR( 32 ) NOT NULL DEFAULT '',`status` TINYINT( 1 ) NOT NULL DEFAULT '0',`default` TINYINT( 1 ) NOT NULL DEFAULT '0',PRIMARY KEY ( `id` )) TYPE = MYISAM AUTO_INCREMENT =1; MySQL said: #1064 - 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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 19 3 Quote Link to comment Share on other sites More sharing options...
schimpfk Posted May 20, 2013 Share Posted May 20, 2013 On the line #19 type:TYPE=MyISAM AUTO_INCREMENT Quote Link to comment Share on other sites More sharing options...
Ice IT Support Posted May 21, 2013 Share Posted May 21, 2013 It should be ENGINE, and the DEFAULT CHARSET should also be defined: ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1; 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.