Support » Fixing WordPress » Backing up only comments, posts, and related data

  • I am trying to move my stuff from to (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’s guide to backup and restore, and I came up with an error screen saying:

    SQL query:
    -- --------------------------------------------------------
    -- Table structure for 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',
    cat_ID ) ,
    category_nicename ( category_nicename )
    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!!!

Viewing 5 replies - 1 through 5 (of 5 total)
  • That documentation you found is a bit outdated. See the newer one:
    (and it also has a “restore” section).

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

    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 🙂

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

    Well, what the “installation” does: creates the tables in the database and inserts the Hello world post 🙂
    What I outlined above – should work.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Backing up only comments, posts, and related data’ is closed to new replies.