Support » Miscellaneous » Consolidate databases

Consolidate databases

  • Bryan Villarin


    Happiness Engineer at Automattic

    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

Viewing 6 replies - 1 through 6 (of 6 total)
  • 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.

    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.

    Bryan Villarin


    Happiness Engineer at Automattic

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

    Kafkaesqui: Thanks! So whaddya suggest?

    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.

    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. :)

    Bryan Villarin


    Happiness Engineer at Automattic

    Thanks guys! I’ll try that out soon enough and give you both a holler how it goes – and hopefully I get to #5. 😉

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Consolidate databases’ is closed to new replies.