I have two backups for comments on my blog. I need to merge them, but I can’t figure out how – if I import one file, it overwrites whatever was there, so I either end up with one set of comments (several years worth, from the beginning until nine days ago) or the other set (comments for the last nine days).

Any of you database geeks willing to help me out?

 

One Response to MySQL Help!

  1. Emo says:

    Michelle:

    Send me what you’ve got: blog version, database version, and the SQL scripts. It sounds like the row-IDs of the old posts are the same (largely) as the row-IDs of the news ones. It should be a straight-forward case of changing the new post’s row-IDs to be non-conflicting with the old rows.

    Isn’t New York the best? I was so impressed when I went there in the mid-90s for a whole week. I walked through Times-Square everyday to get to from my hotel to the office where I was working. Like you, was expecting a scary/funky/hostile vibe. But no, the people were great. Even the bums were cool. I visited again in 2002 — loved it.

    -Emo