Forums

Switching WordPress Databases (11 posts)

  1. Moonlaugh
    Member
    Posted 2 years ago #

    I've been looking all over the internet for this, and I've found out how to switch servers, domains, and many more, but I think mine is a special case.

    Basically, I have two blogs set up on the same domain in different databases.

    One can be reached through http://www.examplesite.com/blog

    The other through http://www.examplesite.com/otherblog

    What I need to do is put otherblog in the same database as blog, because I need to be a ble to share user tables.

    Everything I've tried hasn't worked, even the wordpress guide for moving wordpress.

  2. whooami
    Member
    Posted 2 years ago #

    the ONLY thing that controls the db being used are the connection settings inside the wp-config.php -- thats where the db connection settings are.

    if you want to share the user table, then see this:

    http://wordpress.org/support/topic/164758?replies=13

  3. Moonlaugh
    Member
    Posted 2 years ago #

    Yes. I have read that, and many others. The problem is, the blogs have to be in the same database to work.

    I tried editing wp-config.php as well and the blog I'm trying to move broke.

    As far as I can tell, I haven't done anything wrong, but it's still not working.

  4. whooami
    Member
    Posted 2 years ago #

    I tried editing wp-config.php as well and the blog I'm trying to move broke.

    of course it did. there are 2 url settings inside the db that tell wordpress where the blog install is and at what url.

    You are NOT moving a blog, btw. Not the way you are describing it.

    You are attemtping to share ONE database between TWO blogs.

  5. Moonlaugh
    Member
    Posted 2 years ago #

    Yes. Exactly. I don't mean literally 'move'.

    What URL settings do I need to change in order to make them both work?

  6. whooami
    Member
    Posted 2 years ago #

    if Im going to help you, you need to slow down, and do a little critical thinking.

    Youve just asked, "What URL settings do I need to change in order to make them both work?"

    you have 2 blogs at separate urls. Obviously you cannot just change url settings in either of the dbs.

    Each blog has its own url. You cant have 2 wordpress installs at the same url.

    So the answer to your question is "none".

    lets start from the beginning.

    Is the goal to share content, Or JUST the user information?

  7. Moonlaugh
    Member
    Posted 2 years ago #

    Just user info. One blog is a comic strip, the other is just a blog. I need them to be able to share user tables.

  8. whooami
    Member
    Posted 2 years ago #

    Ok, so you move ONE blog's tables into the other database. If both blogs are using the same prefix (wp_) you change the prefix on ONE of the blogs.

    You will need to edit the wp-config.php's mysql info for the blog you moved into the other db.

    Than you follow the instructions youve already been reading.

    Here they are again:

    http://justintadlock.com/archives/2008/09/20/installing-two-wordpress-blogs-with-the-same-users

  9. whooami
    Member
    Posted 2 years ago #

    Ok, so you move ONE blog's tables into the other database. If both blogs are using the same prefix (wp_) you change the prefix on ONE of the blogs

    To elaborate: All of this can be done using phpmyadmin. Look under the operations tab.

  10. Moonlaugh
    Member
    Posted 2 years ago #

    I was able to do all of that, but now it says I don't have permission to access the Dashboard.

    You do not have sufficient permissions to access this page.

    EDIT: also, is there a way for both blogs to share both tables, as in, just combine the two?

    Because I have a user that signed up on Blog A but not Blog B, and a user that signed up on Blog B but not Blog A. And Blog B user isn't showing up on Blog A's user tables.

  11. Moonlaugh
    Member
    Posted 2 years ago #

    Also, I checked the usermeta tables in the database and it says that my permissions are the same in both.

    I redid it, and now I can't log into either the main or the secondary blog.

Topic Closed

This topic has been closed to new replies.

About this Topic