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)

  • 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.