New to the community? Start here

Having trouble downloading a database

I am running WPMu 2.7 and I an going to be installing the multi data base plugin soon.

But When I went to download a zip of my database, I discovered that essentially I am getting a zipped folder with nothing in it.

I tried to start a download using phpMyAdmin, but all I get was an empty zip file.

The cpanel us running version 2.11.9.4 of myphpadmin. I am following EXACTLY the instructions in the codex: http://codex.wordpress.org/Backing_Up_Your_Database

Is there something I am missing?

Sat, 28 Mar 2009 4:22:55
  • blogpeoria
    • Flash Drive

    Oh yes. Followed the instructions to the letter. All were selected. I’ve been told my database is too large and it essentially times out. I have something like 375 tables. I’ve gone through and dropped many tables, repaired the tables recently. Still nothing doing. Is there any way to give myphpadmin more time before it times out?

  • drmike
    • DEV MAN’s Mascot

    This is a bit of an advanced topic and if you don’t understand, that’s fine. One of things I’ve noticed over the years with CPanel, Direct Admin, and other hosting platforms I’ve used is while they say the accounts are separate, that’s not always true. What we’re doing is creating a separate hosting account just for the databases alongside the wpmu installs. For example, you’ll have an account for wpmuinstall.tld, create an additional account for db.wpmuinstall.tld and put the databases and only the databases into that second account. Even if it’s in a separate account, as long as you;re using the correct username, password, and hostname (which may have to be the actual url of the second account) you’ll have access. The neat thing is 1) if you ever expand into multiple servers, the databases are already separate and 2) it;s easier to do backups since it;s smaller sizes and you’ll be able to backup the databases simply by doing an account backup.

    Does that make sense?