Support » Installing WordPress » MySQL 4.1.14 to 4.0.24…can’t create database

  • Resolved thorlin

    (@thorlin)


    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.

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL 4.1.14 to 4.0.24…can’t create database’ is closed to new replies.