Ready to get started?Download WordPress


[resolved] Importing Comments CSV - Date is wrong (3 posts)

  1. drummergirl
    Posted 7 years ago #

    I'm moving a blog from one site to another for a client, which involved exporting his comments db to a csv file, cleaning it up and then importing it to the new site. When I imported, all the data came through perfectly except the dates all show 12:00:00am on December 31, 1969 for every single comment. When I open the csv file, the dates are correct. Any idea how I can fix this?

    I used neo office to open the file and edit the data, if that piece of info helps anything. Thanks.

  2. drummergirl
    Posted 7 years ago #

    I should also add here that when I imported the blog posts using the same method, the dates were fine. I am importing and exporting via phpmyadmin.

  3. drummergirl
    Posted 7 years ago #

    Ok - nevermind. I imported the old table into the new database then changed the names of the tables, which swapped the new data with the old data. Perfect.

Topic Closed

This topic has been closed to new replies.

About this Topic