Moving to new host (same domain) & database issues

  • I am moving my wordpress blog to a new host (I had the MOST HORRIBLE HOSTING COMPANY EVER).

    I’ve got database backups of my wordpress blog, I’ve got a full site backup. I’ve got every possible backup ever.

    Except, I cannot restore my wordpress databases. My current host — who despite giving me issues now is loads better than my previous host — just now said I cannot upload a database greater than 2 MB. My wordpress db clocks in at just over 6 MB. I don’t know how to break up the .sql file to make it work

    And I can’t stand to lose everything I’ve had for years and years…

    Anyone else know what I can do to break up my DB?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter pineapple

    (@pineapple)

    I also get this error when I try to upload the .gz database backup I downloaded with Skippy’s plugin.

    Error

    SQL query:

    # WordPress MySQL database backup
    #
    # Generated: Friday 6. April 2007 16:00 CDT
    # Hostname: localhost
    # Database: kglgags_wrdp1
    # ——————————————————–
    # ——————————————————–
    # Table: wp_categories
    # ——————————————————–
    #
    # Delete any existing table wp_categories
    #
    DROP TABLE IF EXISTS wp_categories ;

    MySQL said: Documentation
    #1046 – No Database Selected

    Thread Starter pineapple

    (@pineapple)

    this as well. Sorry to be posting so much, but I have to keep switching back & forth between sites.

    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 ) ,
    UNIQUE KEY cat_name ( cat_name ) ,
    KEY category_nicename ( category_nicename )
    ) ENGINE = MYISAM AUTO_INCREMENT =21DEFAULT 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 ‘ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1’ at line

    Hi, first of all check that your new host meets the minimum requirements for WP. Your 3rd post suggests that the db version may be different (older?).

    You can try breaking up the db backup by tables – starting just before “# Table structure…” and finishing just after “UNLOCK TABLES;”. The thing is that your “wp_posts” table will probably be still over the limit, so you will have to break it further. If you have a xml backup (WP2.1) that may work better.

    The “No Database Selected” error – are you sure the name of the new db is “kglgags_wrdp1”? If not – change it to the right one.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Moving to new host (same domain) & database issues’ is closed to new replies.