Export comments.. it gets tricky

  • Hey everyone!

    Im trying to move a pretty big wordpress site to a new subdirectory… I have exported all the main content (pages, posts, comments, categories, tags, etc) but there is a catch. This blog has several comments on a daily basis and I will be working on a separate installation which is why i exported the content. Lets say it takes me about a week or two to get everything running, how can I then export the comments that were left in that specific time frame? (without creating duplicates of the ones that were imported the first time).

    Hopefully its clear enough but I’d be happy to explain further if necessary ??

    Thanks a bunch!

    Alex

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

  • The comment_ID field in the wp_comments table is unique. Don’t duplicate it when you synchronize.

    My suggestion: get it working, dump the database on the new site, put the first site into maintenance mode, export the first site’s database, import the fresh database. You are asking for trouble trying to synchronize two sites that have being running distinctly for several weeks.

    Do not import content until the very end. After all, you’ll need to be able to assign authorship to the posts on import if you haven’t migrated them yet, and you wouldn’t likely add user accounts (other than your admin) until you had everything else working. When the framework of the new site is ready to go live, then as s_ha_dum suggests, plan a maintenance window, take the original site into maintenance and do an export.

    P.S. dumping the database and replacing it with the one from the first site will likely undo many of the changes you were attempting to accomplish.

    If you have already imported the content into your dev install and are worried about duplicates, it may be worthwhile to look into a mass-delete plugin.

    P.S. dumping the database and replacing it with the one from the first site will likely undo many of the changes you were attempting to accomplish.

    Yes, it will. You want to use a more sophisticated database export/import mechanism than a simple database dump, despite my having used ‘dump’ in my previous post.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Export comments.. it gets tricky’ is closed to new replies.