Title: Old db dump, New version. SQL command lines help needed
Last modified: August 18, 2016

---

# Old db dump, New version. SQL command lines help needed

 *  [versus2](https://wordpress.org/support/users/versus2/)
 * (@versus2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/old-db-dump-new-version-sql-command-lines-help-needed/)
 * I have made a clean installation of the new version (2.1).
    Then i imported a
   v2.0.7 dump file of the following 3 tables only (it replaced the default ones):
 * wp_categories
    wp_post2cat wp_posts
 * It doesn’t work (tho it shows it on the sidebar).
 * Is there some kind of SQL command lines i can run that will fix those 3 tables
   to fit v2.1 ??
 * Thanks

Viewing 6 replies - 1 through 6 (of 6 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/old-db-dump-new-version-sql-command-lines-help-needed/#post-508178)
 * I think you would be better taking a complete 2.0.7 blog, upgrade that to 2.1
   then in the Admin panels, delete what you don’t want.
 * Addtional Resources:
    [Upgrading WordPress](http://codex.wordpress.org/Upgrading_WordPress)
   [Moving WordPress](http://codex.wordpress.org/Moving_WordPress)
 *  Thread Starter [versus2](https://wordpress.org/support/users/versus2/)
 * (@versus2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/old-db-dump-new-version-sql-command-lines-help-needed/#post-508182)
 * Ye, I know there are better ways to upgrade, but i need this solution for a good
   reason. Don’t even ask 🙂
 * What actually needed is to know what changes has been made in these tables and
   update it accordingly..
    I don’t know SQL well unfortunately…
 *  [Obvious](https://wordpress.org/support/users/obvious/)
 * (@obvious)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/old-db-dump-new-version-sql-command-lines-help-needed/#post-508193)
 * Okay, I don’t ask.
 * There may be a way to accomplish your task but it’s not easy and involves in 
   depth knowledge of WordPress and SQL. So based on your skills I would recommend:
   Don’t even ask 🙂
 *  Thread Starter [versus2](https://wordpress.org/support/users/versus2/)
 * (@versus2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/old-db-dump-new-version-sql-command-lines-help-needed/#post-508576)
 * Well.. That’s why i’m looking for someone with indepth knowledge of WordPress
   and SQL to help me figure it out….
 *  [ajd777](https://wordpress.org/support/users/ajd777/)
 * (@ajd777)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/old-db-dump-new-version-sql-command-lines-help-needed/#post-508578)
 * I do not guarantee any of these will work, so don’t cry if your dog dies from
   this…
 * UPDATE wp_posts SET post_status = ‘published’, post_type = ‘page’ WHERE post_status
   = ‘static’
    UPDATE wp_posts SET post_status = ‘inherit’, post_type = ‘attachment’
   WHERE post_status = ‘attachment’ ALTER TABLE `wp_categories` ADD `link_count`
   BIGINT , ADD `posts_private` TINYINT , ADD `links_private` TINYINT
 * Manually change the status to ‘future’ for any future posts.
 *  Thread Starter [versus2](https://wordpress.org/support/users/versus2/)
 * (@versus2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/old-db-dump-new-version-sql-command-lines-help-needed/#post-508802)
 * #1064 – You have an error in your SQL syntax; check the manual that corresponds
   to your MySQL server version for the right syntax to use near ‘UPDATE wp_posts
   SET post_status = ‘inherit’, post_type = ‘attach
 * Any idea ?

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Old db dump, New version. SQL command lines help needed’ is closed to
new replies.

## Tags

 * [dump](https://wordpress.org/support/topic-tag/dump/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 6 replies
 * 4 participants
 * Last reply from: [versus2](https://wordpress.org/support/users/versus2/)
 * Last activity: [19 years, 3 months ago](https://wordpress.org/support/topic/old-db-dump-new-version-sql-command-lines-help-needed/#post-508802)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics