WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] MySQL 4.1.14 to 4.0.24...can't create database (4 posts)

  1. thorlin
    Member
    Posted 8 years ago #

    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.

  2. Mark (podz)
    Support Maven
    Posted 8 years ago #

    You need to get rid of
    DEFAULT CHARSET=latin1

    If you have the .sql file open in a text editor, just do a search/replace.

  3. Beel
    Member
    Posted 8 years ago #

    Podz beat me, cuz I was searching the forum for you...
    http://wordpress.org/support/topic/38108

  4. thorlin
    Member
    Posted 8 years ago #

    Seems to have worked like a champ...thanks.

Topic Closed

This topic has been closed to new replies.

About this Topic