WordPress.org

Ready to get started?Download WordPress

Forums

Backing up only comments, posts, and related data (6 posts)

  1. strausser
    Member
    Posted 7 years ago #

    I am trying to move my stuff from stupidcomplexities.com to janicelo.com/blog (to a new host as well), I first tried with backupmyblog's restore function, but it turned out the hyperlinks are all pointing back to my old domain. Then I followed faq.wordpress.net's guide to backup and restore, and I came up with an error screen saying:

    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 DEFAULT CHARSET = latin1 AUTO_INCREMENT =44;
    MySQL said:
    #1050 - Table 'wp_categories' already exists

    ----

    Should I not install wordpress before restoring? Or is there any method I can only backup and restore comments, posts, and other related data, such as wordpress categories?

    PS my previous domain is running 2p 2.0.3, but I have already upgraded it to 2.0.5 before backup, so I pressume that we can rule out the failure due to a 2.0.3 to 2.0.5 restoration.

    Many thanks!!!

  2. moshu
    Member
    Posted 7 years ago #

    That documentation you found is a bit outdated. See the newer one:
    http://codex.wordpress.org/Backing_Up_Your_Database
    (and it also has a "restore" section).

  3. strausser
    Member
    Posted 7 years ago #

    hi moshu, i think they are showing the same backup method

  4. moshu
    Member
    Posted 7 years ago #

    Should I not install wordpress before restoring?

    You don't really need it.
    I mean this should also work:
    - upload the same version WP files as the old (source) installation
    - have the empty DB created and the config file pointing to it
    - do not try to view the "blog" in a browser
    - restore/import the tables into the DB from the backup file
    - go into the options table and change site_url and home values to match your new domain and location

    re: PS. - if you upgraded it to 2.0.5 then it is NOT running 2.0.3 :)

  5. strausser
    Member
    Posted 7 years ago #

    So it means I can just forget all the installation? and just restore my backups will do?

  6. moshu
    Member
    Posted 7 years ago #

    Well, what the "installation" does: creates the tables in the database and inserts the Hello world post :)
    What I outlined above - should work.

Topic Closed

This topic has been closed to new replies.

About this Topic