Support » Fixing WordPress » Importing Comments CSV – Date is wrong

  • Resolved drummergirl


    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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.

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Importing Comments CSV – Date is wrong’ is closed to new replies.