Support » Networking WordPress » Copying multisite database content to new database

  • Resolved Roy

    (@gangleri)


    I’ve got a multi setup with one main and five subsites. Because my host cannot run MySQL 5 with their current software, they’ve created a bypass to allow Joomla (and soon WP) users to run their software requiring MySQL 5. They’ve got one server running MySQL 5 on which only they themselves can set up a database. So now I’m trying to find a way to copy my existing multisite database on another server to the new database that I’m going to need as soon as 3.2 is released. What would be the easiest way to do this?
    Exporting/importing using the WP function does not sound much of an option. This would mean that I edit wp-config, install WP anew, probably loose my network, set it up again and import the exports.
    Would it work when I use the Plesk database export and the PHPmyAdmin import or is this going to give problems due to different software?
    Alternatives?
    Basically I need to copy my database to a database running on other software.

Viewing 15 replies - 1 through 15 (of 25 total)
  • Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    Use the phpmyadmin export function.

    I’ll give it a go. I don’t know what such an export do, but I guess it just makes a file of tables and content then? Sounds like a good way to go.

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    It makes a complete copy of every single table in the db and all its content. Like a backup does. If you ever need to move or restore the db, this is what you do.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    Pretty much 🙂

    Hm, 21 MB is too big a file. I’ve looked around a bit to see what I can do about that, but practically I have but a database admin with no serverspace it seems. I don’t know my way around PHPmyAdmin enough to find ini files or anything, so I just asked my host to allow some more import 🙂

    It’s even worse. The 21 MB file was corrupt. Yesterday I’ve made several efforts to make an export. Most of the time the browser of the entire computer crashed, one time I got a 160 MB file that doesn’t open in Notepad and another time I got a 24 MB zip file that I also can’t open using Notepad. Gzip didn’t work at all. How big a file can a DB dump be of 6 sites with only a few thousand posts? 160 MB sounds way too big for me.
    I’m in contact with my host to see how to proceed.

    An alternative could be to use WP exports of the six sites, but I don’t really want to set up the network anew…

    My host took care of this. As of now (I’m at work) I can look through tht database and it looks alright. Now I’ll experiment a little with wp-config.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    And THAT is why I advocate paying good money to good hosts 😀 ! Yay!

    I pay little money for a descent host 🙂
    No seriously, it’s about the cheapest host in my country. One of these 300 sites per server, no telephone helpdesk kind of hosts. But they help out, think with me and even gave a how-to for the next time.

    But ehm, a 160 MB export for a 6 site multi setup with only a few thousand posts and almost no comments, isn’t that a bit gigantic?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    That does seem a bit large. o.O A lot of plugins and options perhaps?

    Not excessive I think (20, 25 only a few of which are used on all subsites), a stats plugin, four anti spam (akismet and bad behavior don’t need my database I think), custom post types, alphabetical overview, multisite cross posting, that sort of things, nothing much which needs extra database tables.
    Oh well, I’m going home now, look a bit through the database and see what happens when I have WP use the new database.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    Actually bad behavior DOES use your DB but my biggest site is only 22 MB. Then again, I’m sure Andrea has a big daddy out there 😉

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    Aw yeah, I’ve seen some huge ones. 🙂

    The db can fill up really big if:

    – you have post revisions on, which they are by default
    – you don;t empty spam. plugins often mark comments as spam, then leave them in the db. Akismet cleans ’em out after 30 days, but in the meantime, they can fill up.
    – transient feeds in the options tables. I really do not like how the dashboard feeds get saved in the db for every. single. site.
    – optimize the tables before export. deleting stuff leaves emty spaces that take up actual space. 😀

    And in phpmyadmin, you don’t have to select all tables. you can select some, do a zip, select the next batch, do another zip.. .and keep going. Sucks, but it works.

    No for revisions.
    No for spam.
    No idea for ‘trasient feeds’?
    4, Thanks for the tip.

    New problem btw. I started using the new database and noticed that ALL accented characters, but even just symbols such as ‘ or > have been replaced by code (no html codes btw, I didn’t recognise the coding). That’s a bit too much work to replace, about as much as just copying everything to the new database actually, since I doubt I’ll have even one post withouth and Ill.
    Tips?

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    db collation is my guess.

Viewing 15 replies - 1 through 15 (of 25 total)
  • The topic ‘Copying multisite database content to new database’ is closed to new replies.