Title: Ver quick SQL db edit question
Last modified: August 19, 2016

---

# Ver quick SQL db edit question

 *  Resolved [Will Taft](https://wordpress.org/support/users/wt/)
 * (@wt)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/ver-quick-sql-db-edit-question/)
 * I have a new install of WP and imported data from the wp -comments, users, posts
   and the multiple wp_terms… tables in the older install. Everything is OK except
   that the new db has fewer users. My user id in the new db is 2. In the old db
   it was 8. So all the posts are shown as being authored by 8 in the wp_post table.
   Can I just change my user id in the wp_users table from 2 to 8? Or is there a
   better way to re-associate all the posts to me?
 * I suppose I could import the old wp_users table from the old db, but there are
   a bunch of users in there I would then need to delete.
 * Thanks.

The topic ‘Ver quick SQL db edit question’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [Will Taft](https://wordpress.org/support/users/wt/)
 * Last activity: [18 years, 3 months ago](https://wordpress.org/support/topic/ver-quick-sql-db-edit-question/)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics