can’t restore mysql database

  • pipsy

    (@pipsy)


    19 years ago

    hi. i’m moving servers, and just backed up my database.
    now when i try to load that database into my new server i keep on getting this error:

    SQL query:

    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 =6

    MySQL said: Documentation
    #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=6’ at line 10

Viewing 4 replies - 1 through 4 (of 4 total)
  • bobmorris60

    (@bobmorris60)

    Maybe your new server doesn’t support ‘latin1’ as a DEFAULT CHARSET. This is the version of the alphabet that it uses.

    Call your tech support and ask to speak to someone who understands mySQL.

    vkaryl

    (@vkaryl)

    All you need to do is open the file in something “vanilla” like notepad2, and edit out DEFAULT CHARSET=latin1. Now there might be other errors as well; I’ve occasionally had to edit out ENGINE = MYISAM too. But start with removing the DEFAULT CHARSET=latin1 statement. Be sure you leave one space between ENGINE = MYISAM and AUTO_INCREMENT =6

    Oh. You’ll need to edit every table structure section; pretty much all of them include the same stuff.

    Thread Starter pipsy

    (@pipsy)

    it did what you suggested, and it worked!

    thank you for your help!

    vkaryl

    (@vkaryl)

    You’re welcome! Have fun….

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘can’t restore mysql database’ is closed to new replies.