I am changing hosting services and I am, unfortunately, moving from MySQL 4.1.14 to MySQL 4.0.24. I exported my database and have my .sql file, however when I try to run the sql I get an the following error after trying to create the first table wp_categories.
#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 AUTO_INCREMENT=7' at line 10
The SQL statement is:
DROP TABLE IF EXISTS wp_categories;
CREATE TABLE wp_categories (
cat_ID bigint(20) NOT NULL auto_increment,
cat_name varchar(55) NOT NULL default '',
category_nicename varchar(200) NOT NULL default '',
category_description longtext NOT NULL,
category_parent int(4) NOT NULL default '0',
PRIMARY KEY (cat_ID),
UNIQUE KEY cat_name (cat_name),
KEY category_nicename (category_nicename)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
I'm not very familiar with MySQL so I'm not sure what the syntax problem is. Please let me know so I can properly modify my .sql file.
Thanks.
