Restore Data Base Error

  • I am moving to a new server and have backed up the entire web site at https://metaltiger.org as well as the Data Base. The restore data base on the new server is giving me syntax errors :

    Error

    SQL-query:

    #
    # Table structure of table 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 bigint( 20 ) NOT NULL default ‘0’,
    category_count bigint( 20 ) NOT NULL default ‘0’,
    PRIMARY KEY ( cat_ID ) ,
    KEY category_nicename ( category_nicename )
    ) ENGINE = InnoDB DEFAULT CHARSET = latin1

    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’ at line 14

    I am not sure where to go from here to restore the data base. Thanks.

    David

Viewing 3 replies - 1 through 3 (of 3 total)

  • “DEFAULT CHARSET = latin1”

    Open the .sql file in a plaintext editor and do a search/replace
    Replace “DEFAULT CHARSET = latin1” with nothing and all should be well.

    Thread Starter metaltiger

    (@metaltiger)

    Podz, does this mean that I just remove the
    “DEFAULT CHARSET = latin1” or do I change it to

    “DEFAULT CHARSET = “

    Thanks
    David

    Remove it ??

    (Apologies for not being clearer!)

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Restore Data Base Error’ is closed to new replies.

Tags