WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] importing database into new server mysql ERROR (3 posts)

  1. ore
    Member
    Posted 7 years ago #

    im finally moving my blog from localhost to a more prominent location—online. When attempting to import the database, this problem occured:

    "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=5' at line 10 "

    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 bigint( 20 ) NOT NULL default '0',
    category_count bigint( 20 ) NOT NULL default '0',
    PRIMARY KEY ( cat_ID ) ,
    KEY category_nicename ( category_nicename )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =5

    so what should i do? p.s. this might help, to be sure that the file isnt corrupted, i uploaded it to my localhost database and it worked perfectly.

  2. brokenshardz
    Member
    Posted 7 years ago #

    i am also getting the same error. msql version for both sites are the same, 4.1.21-standard.

  3. spencerp
    Member
    Posted 7 years ago #

    I noticed you marked this [Resolved], but, can you let everyone else know what you did to "Resolve" it? This might help others that are having the same problem as you had.. =) ;)

    spencerp

Topic Closed

This topic has been closed to new replies.

About this Topic