• Resolved criscollrj

    (@criscollrj)


    Hello – I’ve been trying to move my wordpress blog into a new host, but same domain name. I am getting the following error:

    Error
    SQL query:

    TABLE structure FOR 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 = MYISAM AUTO_INCREMENT =17;

    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 ‘Table structure for table wp_categories

    CREATE TABLE wp_categories (
    `’ at line 1

    when I try and copy the contents of the file criscol2_wrdp1 into the sql window of phpmyadmin.

    I have read many posts on here about how to move the wordpress blog database, and several errors encountered and what to do. I have gone in and taken out the charset=latin one as was instructed to many people. I also downgraded my wordpress blog from 2.0 (whatever the latest one is) to a 1.5 as someone was instructed that maybe they were having errors because their file backup was an older version than the blog (I am sure that was the case with me) That did not help either.

    I have had a support ticket in at my new host since Sunday to transfer my site, but nothing has yet happened. I would like to do myself if possible to go faster but have had no luck.

    I know I can manually import all my blog entries from Qumana [thank God I have that at least!] but that will take a long time and will still not give me back all my comments. I also had a lot of formatting to several pages outside of comments.

    Any additional help will be greatly appreciated!

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Error, can’t move sql database into new host (same domain)’ is closed to new replies.