Large database backup and restore

  • Resolved eswrite-wp

    (@eswrite-wp)


    12 years, 1 month ago

    I’m running into an issue with my ISP provider where I can backup my database, currently over 15MB, but I can’t restore it because the MySQL/phpMyAdmin Import function has a 8-10MB (depending on which tech I’m talking with) limit.

    I’m thinking I will have to backup my database in portions, say 1/2 of the tables in one backup, the other half in the other, but I’m worried of how a partial restore works. If I only restore some tables and not others (with the idea that I will follow up with the rest in a subsequent restore), will database table and record links break?

    If not like this, how would you recommend doing the restore otherwise?

    I am trying to avoid having to FTP the file to the ISP technicians to have them do the restore for me because, honestly, given their seeming lack of WordPress know-how, I don’t trust them.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Mark Ratledge

    (@songdogtech)

    12 years, 1 month ago

    You can export half the tables at a time and import them that way, too.

    But delete your revisions and clean the database and you might be able to get it under the 8 meg limit.

    http://wordpress.org/extend/plugins/better-delete-revision/

    Thread Starter eswrite-wp

    (@eswrite-wp)

    12 years, 1 month ago

    I’m assuming there’s no concern of broken linkages, etc. Thanks for the tip on DB clean-up. I’ll look into that.

    Tim S

    (@tim-s)

    12 years, 1 month ago

    Also, importing the database, really has nothing to do with working in WordPress, your hosting provider will likely use the commandline to do so. It’s actually far easier to import when they do it. Like songdogtech said, you can try to clean up your database and reduce it’s size. If not, I’d recommend letting your host import the data for you.

    Thread Starter eswrite-wp

    (@eswrite-wp)

    12 years, 1 month ago

    Thanks, Tim. Working on that at the moment, seeing if they can set it up as an additional database rather than replace/rewrite the existing one… just in case. I would like to see if I can carry out the whole process myself. Right now it’s not crucial because my website is up and running, but in the case where my site is down, I’m going on 12 hours since I put in the import database request.

    Tim S

    (@tim-s)

    12 years, 1 month ago

    Sure, I understand. Typically, they’re going to create a new database, and import all the data into that. Then you can get the DB credentials to configure the wp-config.php file. I like to do things myself as well, so I know the feeling. Good Luck!

    Thread Starter eswrite-wp

    (@eswrite-wp)

    12 years, 1 month ago

    @songdogtech: thanks again. That did the trick, reducing the database size to less than 4MB (1/4 the size!). After that, I was able to do some additional clean-up to update old HREF links, updated, and voila! I’m up and running after changing the wp-config.php file. Very nice.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Large database backup and restore’ is closed to new replies.