MySQL 4.1.14 to 4.0.24…can’t create database
-
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 TABLEwp_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 KEYcat_name
(cat_name
),
KEYcategory_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.
- The topic ‘MySQL 4.1.14 to 4.0.24…can’t create database’ is closed to new replies.