after manually transferring a database, I logged in to the admin panel, which asked me to upgrade the database.

Now, all of my content from several different posts types all appear as a post. This was not the case before the upgrade, as the site worked and all the content was in the right place.

I have the SQL still, so I can copy it all in again, but I am concerned this will just happen again.

Any work arounds?

link|improve this question

74% accept rate
Not completely sure but thought I would put my two cents in here. Can you skip out the posts in the SQL and use WP's Export/Import feature for the posts? – Jared Jan 15 at 19:01
there is just so many, would take an age using that function – Mild Fuzz Jan 15 at 19:02
Are you going from one version of wordpress to another, or are you staying in the same version? – m0r7if3r Jan 15 at 19:16
Can't you just update the type field in wp_posts based on the content of your sql file (instead of reimporting the full table which may trigger a database update if the structure is not the same)? – Jordi Cabot Jan 15 at 19:52
how can I do that? – Mild Fuzz Jan 15 at 20:55
show 2 more comments
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.