sql help?

[milkit]

Trying to import a sql file into a new DB i made.

i get this error when i go to import it

PHP Code:

"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 'DEFAULT CHARSET=latin1' at line 14 " 


and the basics of what im importing is

PHP Code:

DROP TABLE IF EXISTS `exporter`;
CREATE TABLE `exporter` (
  `gal_id` int(11) NOT NULL auto_increment,
  `gal_title` text NOT NULL,
  `gal_link` text NOT NULL,
  `site_name` text NOT NULL,
  `nn_nude` varchar(4) NOT NULL default '',
  `gal_short` text NOT NULL,
  `gal_long` text NOT NULL,
  `num_thumbs` int(11) NOT NULL default '0',
  `pic_vid` char(3) NOT NULL default '',
  `thumb_url` text NOT NULL,
  `site_url` text NOT NULL,
  PRIMARY KEY  (`gal_id`)
) ENGINE=INNODB DEFAULT CHARSET=latin1; 


Any ideas?

[milkit]

mysql (4.0.22-standard) btw

[jwerd]

ENGINE=INNODB DEFAULT CHARSET=latin1;

I am going to say the engine declare. If you don't need it to be specifically MyIsam, take it out and see if that works... it should. Basically it's like forcing it to one type and sometimes the different types aren't accepted for that specific charset or engine type. Goodluck!

[jwerd]

Nvm,
`gal_id` int(11) NOT NULL auto_increment,

it should be:
`gal_id` int(11) auto_increment NOT NULL ,

[milkit]

so try it as

[HTML]DROP TABLE IF EXISTS `exporter`;
CREATE TABLE `exporter` (
`gal_id` int(11) NOT NULL auto_increment,
`gal_title` text NOT NULL,
`gal_link` text NOT NULL,
`site_name` text NOT NULL,
`nn_nude` varchar(4) NOT NULL default '',
`gal_short` text NOT NULL,
`gal_long` text NOT NULL,
`num_thumbs` int(11) NOT NULL default '0',
`pic_vid` char(3) NOT NULL default '',
`thumb_url` text NOT NULL,
`site_url` text NOT NULL,
PRIMARY KEY (`gal_id`)
) DEFAULT CHARSET=latin1; [/HTML]

?

[jwerd]

Originally Posted by milkit

so try it as

[HTML]DROP TABLE IF EXISTS `exporter`;
CREATE TABLE `exporter` (
`gal_id` int(11) NOT NULL auto_increment,
`gal_title` text NOT NULL,
`gal_link` text NOT NULL,
`site_name` text NOT NULL,
`nn_nude` varchar(4) NOT NULL default '',
`gal_short` text NOT NULL,
`gal_long` text NOT NULL,
`num_thumbs` int(11) NOT NULL default '0',
`pic_vid` char(3) NOT NULL default '',
`thumb_url` text NOT NULL,
`site_url` text NOT NULL,
PRIMARY KEY (`gal_id`)
) DEFAULT CHARSET=latin1; [/HTML]

?

I wrote above what was causing your error. The engine type really would only effect older versions, atleast from what I've learned. Anyways, goodluck!

[milkit]

tried both of those, same error now on all 3 ways

[jwerd]

Hold on, I'll take a look...

[dubsix]

Originally Posted by lamerhooD

I wrote above what was causing your error. The engine type really would only effect older versions, atleast from what I've learned. Anyways, goodluck!

no, thats entirely wrong the CHARSET is not supported in 4.0.x

you'll want to drop the default charset or upgrade to mysql 4.1.x

[milkit]

k fixed i changed

) ENGINE=INNODB DEFAULT CHARSET=latin1;

to

) ENGINE=INNODB;

and it worked. thanks www.wiresix.com for the help :P

[jwerd]

Originally Posted by WireSix-Ryan

no, thats entirely wrong the CHARSET is not supported in 4.0.x

you'll want to drop the default charset or upgrade to mysql 4.1.x

You're right, try what he's said. I thought ever since 4.0.x they offered that. I'm still in the 3.0 days :P