sql help?
 

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

i get this error when i go to import it

and the basics of what im importing is


Any ideas?

mysql (4.0.22-standard) btw

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! :thumbsup

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

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

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! :)

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

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

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

k fixed i changed

) ENGINE=INNODB DEFAULT CHARSET=latin1;

to

) ENGINE=INNODB;

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

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