Consolidate databases (7 posts)

  1. Is there any way to consolidate a couple databases into one? They're all using different table prefixes for WordPress. I'm having to backup three different ones, but I'd prefer to use just one. Or is that not recommended?

    I'm not running out of databases on my server, so that's not the problem. Just trying to make things a bit easier.


    - Bryan

  2. Joshua Sigar
    Posted 11 years ago #

    I haven't gone to phpmyadmin to see if such an option is available. But for sure you could write your own php script to back 'em up at the same time.

  3. Kafkaesqui

    Posted 11 years ago #

    If you choose to go the route of consolidation, it should be no problem. Since they're already using different table prefixes, you're ahead of the game on this.

  4. alphaoide: I don't know PHP, so that's out. =P

    Kafkaesqui: Thanks! So whaddya suggest?

  5. Joshua Sigar
    Posted 11 years ago #

    He'll probably suggest what I suggested or
    Do two backups, you'll get two files, and just copy-n-paste one of them to the other one. There you go, you got one backup. And you could restore two database from that one backup file.

    p.s. I haven't looked at the sql backup file for so long, but I believe you could do the above. You check yourself.

  6. Kafkaesqui

    Posted 11 years ago #

    Me, I'd

    1. Export the two I'm dropping to sql text files (structure and data).

    2. Upload and import them individually to the database I'm keeping.

    3. Re-point the blogs to the correct database.

    4. Make sure all is working as expected.

    5. If 4 is a go, party. :)

  7. Thanks guys! I'll try that out soon enough and give you both a holler how it goes - and hopefully I get to #5. ;)

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.