Title: importing users
Last modified: August 18, 2016

---

# importing users

 *  [faceless105](https://wordpress.org/support/users/faceless105/)
 * (@faceless105)
 * [18 years, 11 months ago](https://wordpress.org/support/topic/importing-users/)
 * I have a friend who setup a number of wordpress blogs, but he actually installed
   each one to a seperate database and now that he’s getting close to his database
   limit he wants them all on one database. I started poking around in the admin
   account and is it possible to export user account from all the other wordpress
   accounts and simply import them into one wordpress install so they are all on
   the same database?
 * If this isn’t an option I’d love if you could instruct me on how I should go 
   about doing this manually. And no need to hold back on the details I’m an php/
   mysql web developer so I don’t have any problem working in the code and databases.
 * I think the import/export option would work but I wanted to ask here first before
   jumping into anything.
 * Thanks for the time.

Viewing 1 replies (of 1 total)

 *  [nettribal](https://wordpress.org/support/users/nettribal/)
 * (@nettribal)
 * [18 years, 11 months ago](https://wordpress.org/support/topic/importing-users/#post-563042)
 * Hi,
 * I think the best way is to carry out the following procedure…
 * 1. back up the database of all available blogs.
    2. Get them into your comp.(
   and save an extra copy too in case you screw up majorly 🙂 ) 3. Now select one
   of the blogs to be your main blog. 4. Open the backed up database for the main
   blog. Go to the user tables (search for the following “Data contents of table`
   wp_users`” here wp_ is the prefix of the database and tables where the main blog
   info is stored) 5. After familiarizing yourself with the format of the users.
   Now open the backup of the blog whose users you wish to import 6. copy paste 
   the user section into the main blog user section. 7. Repeat for all blogs 8. 
   now re-load your back-up into the wp-database for the main blog

Viewing 1 replies (of 1 total)

The topic ‘importing users’ is closed to new replies.

## Tags

 * [importing](https://wordpress.org/support/topic-tag/importing/)
 * [users](https://wordpress.org/support/topic-tag/users/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [nettribal](https://wordpress.org/support/users/nettribal/)
 * Last activity: [18 years, 11 months ago](https://wordpress.org/support/topic/importing-users/#post-563042)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics