WordPress.org

1. arnoz
   Member
   Posted 5 years ago #

   Hey,

   I just changed my host and so I made a backup of my MySQL DB from my old host to import it to my new one. I managed to import everything without any problems: category, users, comments and others are showing perfectly.
   However, I've been working for a long time now on the import of the table WP_posts. This one is correctly imported as the size of the table is the exact same of the old one. But in my dashboard it says "you have x comments and 0 articles"! None of my articles are showing up when I visit my website...
   What did I do wrong? I tried like 50 different kind of imports and I am kind of stuck now...

   Using WP 2.1.3, MySQL 5.0.38 and PHPMyAdmin 2.10.02.

   Thanks!

2. arnoz
   Member
   Posted 5 years ago #

   Please?

3. arnoz
   Member
   Posted 5 years ago #

   Got it! The fields "post_type" in the table wp_posts were empty and it seems there should be something. I made a MySQL query to add the "post" value and now they're showing up :)

4. bsoist
   Member
   Posted 4 years ago #

   Thank you so much for posting the solution.
   When I saw that all three posts were from you I was worried that there was no answer.

   :)

Topic Closed

This topic has been closed to new replies.