Results 1 to 4 of 4

Thread: WP 3.0.1 with BackWPup - small DB backups?

  1. #1
    Just a peon, like you. eracc's Avatar
    Join Date
    Dec 2003
    Location
    USA
    Posts
    180
    Rep Power
    14

    WP 3.0.1 with BackWPup - small DB backups?

    Hi y'all. I've been running WordPress for a LONG time and know most of the "tricks". I've been backing up with phpMyAdmin. I recently decided to try BackWPup to attempt to automate backups. My company blog has 6 static pages, over 100 posts and over 1000 actual comments (all SPAM is gone). A "complete" backup of all the database tables with BackWPup gives me just under a 900k tar.gz backup file. Does that sound correct? It seems small to me, but then the only backups I have seen for WP before now are those done through phpMyAdmin. The last one I did with phpMyAdmin was a straight uncompressed *.sql file of the entire database which was ~12 MB in size.

    I would hate to need to restore a backup and find that using BackWPup is not getting everything. Anyone else using this plugin? If so, what are your experiences with it? TIA!
    Gene Alexander
    ERA Computers & Consulting http://www.eracc.com/ | http://shopping.eracc.com/ | http://blog.eracc.com/ | http://forum.eracc.com/
    Preloaded OSS (Linux, FreeBSD) and eComStation on PCs and Servers.

  2. #2
    Just a peon, like you. eracc's Avatar
    Join Date
    Dec 2003
    Location
    USA
    Posts
    180
    Rep Power
    14
    Oops, that last backup was actually 6.7 MB. The 12 MB was before pruning all the SPAM.
    Gene Alexander
    ERA Computers & Consulting http://www.eracc.com/ | http://shopping.eracc.com/ | http://blog.eracc.com/ | http://forum.eracc.com/
    Preloaded OSS (Linux, FreeBSD) and eComStation on PCs and Servers.

  3. #3
    Mod.. with bite.. Croc Hunter's Avatar
    Join Date
    Sep 2002
    Location
    Australia
    Posts
    7,333
    Rep Power
    27
    Yeah that sounds about right mate. Text compresses extremely well and quickly whereas images and movies do not. I've zipped 4-5 Gig movies before and some only dropped 8-10Mb. Depending on the type of compression and text document you will get upto 10x compression ie: 100Mb down to 10Mb. So 6x in yr case for tar.gz is reasonable.

    Being a company website it would be a good idea to create a second WP test site and import your various backups to see if you got your butt covered. WP itself creates xml backups too.
    Croc Hunter MSC :

  4. #4
    Just a peon, like you. eracc's Avatar
    Join Date
    Dec 2003
    Location
    USA
    Posts
    180
    Rep Power
    14
    Yeah, I know compression is good on text. I was not thinking of the DB as text. But now that you mention it I realize that is all it is. Thanks for the reminder.

    I have a test subdomain set up for Drupal for module tests and demonstrations. I don't know why I did not do that for WP. Good suggestion.
    Gene Alexander
    ERA Computers & Consulting http://www.eracc.com/ | http://shopping.eracc.com/ | http://blog.eracc.com/ | http://forum.eracc.com/
    Preloaded OSS (Linux, FreeBSD) and eComStation on PCs and Servers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •