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?