What if the DB is too big? (7 posts)

  1. DoZ
    Posted 5 years ago #

    It tooks too long to make a backup... Well... It doesn't make the backup at all!
    Maybe because the DB is 10 MB?

  2. strategicblend
    Posted 5 years ago #

    I've had the same issue on various sites. Is there a fix or documented limit?

  3. houseofstrauss
    Posted 5 years ago #

    BigDump Been around ages and still works best. If you're on cPanel, use built in backup and restore. It always works on any size of DB and very reliable

  4. DoZ
    Posted 5 years ago #

    Uhm... nice info!
    Somebody should upgrade WP-DB-Backup to make it fits this need.

  5. DoZ
    Posted 5 years ago #

    For whom PHP speaks...
    Does that...
    ...mean something?

  6. houseofstrauss
    Posted 5 years ago #

    As I understand it, the problem is server time-outs for large DB files. That's why many of these backup plugins allow you to choose which tables to backup, I guess to limit some of the big ones, like comments etc. Cpanel gets around DB size, as it's an internal process. Big-dump spilts and re-combines to keep the job manageable and withing parameters.

    BigDump is not a wordpress plugin, as you can see, but pretty easy to setup and manage as a stand alone script.

    I have pesonally used cPanel backup/restore on DBs over 50 Mb. with no problem... except long upload times, of course :) You'll never get a time out, just make sure to leave the restore page open and active, untill it's finished.

  7. Monika
    Posted 5 years ago #

    I use mysqldumper.net

    this is no WPplugin but it is absolut easy to use,
    you can have multipart backups gzip zip ie
    and cronjobs to do the job for you ;)

    there is no database which is too big for mysqldumper

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP-DB-Backup
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic