Error importing database export (transferring to new host)

  • furie

    (@furie)


    19 years ago

    I followed the instructions on how to export my databases from my old site and now I’m trying to import to my new site using phpMyAdmin. I created the database and tried to import the file but I got the following error:

    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:

    #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 ‘ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6’ at line

    Any suggestions?

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

  • Yup ??

    Open the .sql file with a plain text editor.
    Do a Find/Replace and replace all these
    DEFAULT CHARSET = latin1
    with nothing at all.
    Save the file.
    Upload ??

    Thread Starter furie

    (@furie)

    Thank you for the quick response. I tried that and now I have a smilar error:

    #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 ‘ENGINE=MyISAM AUTO_INCREMENT=6’ at line 10

    Should I remove AUTO_INCREMENT=6 as well?

    Odd.
    If anything I’d remove the ENGINE=MyISAM instead.

    Please be sure to work from a backup though!

    Thread Starter furie

    (@furie)

    I am working off of a backup. So I tried that other value as you suggested and got this:

    #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

    Should I try the Auto_Increment next?

    Thread Starter furie

    (@furie)

    Actually, I just removed both the ENGINE and the CHARSET and it loaded…don’t know if I’ll see any other problems yet but I’ll take a look.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error importing database export (transferring to new host)’ is closed to new replies.