• site home
  • blog home
  • galleries
  • contact
  • underwater
  • the bleeding edge

the last word

Photography meets digital computer technology. Photography wins -- most of the time.

You are here: Home / The Last Word / A new website — WordPress backup requirements

A new website — WordPress backup requirements

October 10, 2016 JimK 3 Comments

This is a continuation of a series of posts about reworking my website into one that is entirely WordPress based. The series starts here.

OK, so I’ve got a new web site, and it’s live. Job done, right? Well, no. Now is the time for one of the least glamorous, but ultimately most important, things in just about any computer system implementation: preparing for a disaster. Disasters come in many forms. There are fires, floods, earthquakes, and things like that. Those are thankfully infrequent, but still need to be considered. Then there are attacks from malicious people — or bots controlled by those people — that could corrupt your site so badly that you’d need to wipe it clean and restore a version from before the attack. Your hosting company could go out of business, or start providing service that’s so bad that you want to move elsewhere. There could be a hardware failure at your hosting company. Or, more likely, there could be a human error or software defect that corrupts your site. And, no matter how careful you are, there’s always the possibility that your yourself could screw up big-time.

For all those reasons, and probably a lot more that I haven’t thought of, you need to back up your data, and you need to back it up to several places, most of which are not on the servers that host your site.

Many people pick a backup solution and never test it. Some of those people find out only when they need to do a restore that there’s something wrong with their backups. You don’t want to be one of those people.

You need to do trial restores to gain confidence in your backups. I know that people don’t like to here that. I don’t like to have to say it, and I hate testing backups, but there it is. Now, as applied to WordPress sites, there is a conclusion that stems form the bold sentence above that may come as a surprise to you: a backup solution must be a migration solution.

Why is that? Because you don’t want to test a backup by restoring a live site. Tell me, how are you going to feel if in testing your backup by doing a restore to your main site if you end up wiping out a perfectly good WordPress instance, and you have no backup in which you have any confidence? Better hide the knives, pills, and guns before you try that. Therefore, any trial restoration has to be to a test site. That makes it a migration.

So, when you look for a backup solution, make sure it can do migration. Migration is sometimes presented as a minor feature of a tool that is advertised for backup. That’s the wrong way to look at it. You’re guaranteed to have to do migrations to test your backups. You may never do a restore to the site that you backed up. In fact, it is unlikely that you will have to. So, in looking for a backup tool, you might start up looking for migration solutions.

With a WordPress instance there are two things that need to be saved: the content files, and the database. If you have images in your content, they are stored outside the database (unless you are stupid enough to put them in-line in your posts, as I did for way too long many  years ago). Aside from that, your pages and posts are stored in the database. You may also want to backup your plugins and themes, especially if you’ve done a lot of customization and aren’t sure where that is stored.

So, the first solution I’m going to propose (and the only one I’m going to talk about in this post) is the conceptually simplest one, but requires the most user involvement. Use ftp to back up your files and directory, and use a database migration tool to back up your data base.

It turns out that I’ve already told you about a database migration tool in this series of posts. I used WP Migrate DB Pro. I used that to migrate the test site at kasson.name to kasson.com/wp1. It worked very well. There are four  modes to the plugin. It can push a datbase to a WordPress site with the plugin installed, it can pull a database from a  site with  the plugin installed, or it can download a database to your computer or upload one from your compute. I used the two peer-to-peer modes for the migration. For backup and backup testing, the database download (backup) and database upload (restore) modes are the ones to use. Unlike many backup pplugins, there is no timed operation for WP Migrate DB Pro; if you go that route, you’ll have to manually invoke it whenever you want to do a backup.

I’ve done a couple of successful migrations/test restores with WP Migrate DB Pro, with WordPress databases of around 10 MB. I’ve had problems with a database of around 500MB. More work is necessary for me to gain confidence in the product as a database backup solution.

 

The Last Word

← A new website — going live A new website — WordPress performance →

Comments

  1. luis says

    October 23, 2016 at 2:31 am

    Hi Jim,
    Why not use “well proven solutions” ? I mean MySQL tools, or for example phpMyAdmin, you can download a backup DB in just seconds and compressed using zip or bzip.

    Also you can do scheduled backups in a shell console, using mysqldump this tool is very well documented and easy to do.
    The same goes for php files in wordpress (tar+gzip), etc….

    Good luck with you migration!

    Reply
    • Jim says

      October 23, 2016 at 8:20 am

      Sure. I was only considering DB tools that operated within the WP environment. The general-purpose SQL tools don’t address the issue of changing information in the database so that you can do trial restores, although I’m sure a SQL expert could figure out how to handle that.

      Jim

      Reply

Trackbacks

  1. A new web site – five backup solutions says:
    October 12, 2016 at 2:53 pm

    […] I mentioned here, I’ve been testing WordPress backup solutions. The ones I’ve been looking at […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

May 2025
S M T W T F S
 123
45678910
11121314151617
18192021222324
25262728293031
« Apr    

Articles

  • About
    • Patents and papers about color
    • Who am I?
  • How to…
    • Backing up photographic images
    • How to change email providers
    • How to shoot slanted edge images for me
  • Lens screening testing
    • Equipment and Software
    • Examples
      • Bad and OK 200-600 at 600
      • Excellent 180-400 zoom
      • Fair 14-30mm zoom
      • Good 100-200 mm MF zoom
      • Good 100-400 zoom
      • Good 100mm lens on P1 P45+
      • Good 120mm MF lens
      • Good 18mm FF lens
      • Good 24-105 mm FF lens
      • Good 24-70 FF zoom
      • Good 35 mm FF lens
      • Good 35-70 MF lens
      • Good 60 mm lens on IQ3-100
      • Good 63 mm MF lens
      • Good 65 mm FF lens
      • Good 85 mm FF lens
      • Good and bad 25mm FF lenses
      • Good zoom at 24 mm
      • Marginal 18mm lens
      • Marginal 35mm FF lens
      • Mildly problematic 55 mm FF lens
      • OK 16-35mm zoom
      • OK 60mm lens on P1 P45+
      • OK Sony 600mm f/4
      • Pretty good 16-35 FF zoom
      • Pretty good 90mm FF lens
      • Problematic 400 mm FF lens
      • Tilted 20 mm f/1.8 FF lens
      • Tilted 30 mm MF lens
      • Tilted 50 mm FF lens
      • Two 15mm FF lenses
    • Found a problem – now what?
    • Goals for this test
    • Minimum target distances
      • MFT
      • APS-C
      • Full frame
      • Small medium format
    • Printable Siemens Star targets
    • Target size on sensor
      • MFT
      • APS-C
      • Full frame
      • Small medium format
    • Test instructions — postproduction
    • Test instructions — reading the images
    • Test instructions – capture
    • Theory of the test
    • What’s wrong with conventional lens screening?
  • Previsualization heresy
  • Privacy Policy
  • Recommended photographic web sites
  • Using in-camera histograms for ETTR
    • Acknowledgments
    • Why ETTR?
    • Normal in-camera histograms
    • Image processing for in-camera histograms
    • Making the in-camera histogram closely represent the raw histogram
    • Shortcuts to UniWB
    • Preparing for monitor-based UniWB
    • A one-step UniWB procedure
    • The math behind the one-step method
    • Iteration using Newton’s Method

Category List

Recent Comments

  • JimK on Goldilocks and the three flashes
  • DC Wedding Photographer on Goldilocks and the three flashes
  • Wedding Photographer in DC on The 16-Bit Fallacy: Why More Isn’t Always Better in Medium Format Cameras
  • JimK on Fujifilm GFX 100S II precision
  • Renjie Zhu on Fujifilm GFX 100S II precision
  • JimK on Fuji 20-35/4 landscape field curvature at 23mm vs 23/4 GF
  • Ivo de Man on Fuji 20-35/4 landscape field curvature at 23mm vs 23/4 GF
  • JimK on Fuji 20-35/4 landscape field curvature at 23mm vs 23/4 GF
  • JimK on Fuji 20-35/4 landscape field curvature at 23mm vs 23/4 GF
  • Ivo de Man on Fuji 20-35/4 landscape field curvature at 23mm vs 23/4 GF

Archives

Copyright © 2025 · Daily Dish Pro On Genesis Framework · WordPress · Log in

Unless otherwise noted, all images copyright Jim Kasson.