The hard place is over there

Taking care of a WordPress operation is a two-pronged affair, inasmuch as the files are stored in two wholly separate locations: the Web server itself contains the WP core files and the design elements, while the actual posts are kept in a database elsewhere.

I download all the graphics and such to my home box before posting, so I already have copies of them in case of Dire Emergency. I hardly ever see the database, though, so a plugin copies it out on a regular basis, gzips the copy, and emails it to me.

Or anyway, it used to email it to me. The database is now so large that the gzipped copy is up to 20 megabytes, just at the point where the mail server balks: “Too big, pal.” For now, I’m fetching it via SFTP, but I’m thinking I ought to be considering other options.





5 comments

  1. Georganna Hancock (@GLHancock) »

    1 March 2015 · 11:48 am

    Your host doesn’t make backup copies? If so, can you access the database and store a copy in a cloud, on a DVD, or get the host to send a copy to a storage facility you can access online?

    This, from the woman who has lost most of her images, email messages and addresses of personal and business contacts. Come to think of it, all of my blog is on the dying hard drive, too.

    Something about cobblers and shoes comes to mine.

  2. CGHill »

    1 March 2015 · 12:05 pm

    The host does indeed make backups, but I don’t want to rely on them if I don’t have to.

  3. Roger Green »

    1 March 2015 · 1:34 pm

    I may ask you about this further…

  4. McGehee »

    1 March 2015 · 3:36 pm

    FWIW, I converted some 7 years’ worth of material to static HTML — the hard way; it was a project of months — to get it out of databases that, while hardly as big as yours, were getting to big for my comfort. And I wasn’t having the backups emailed to me.

    Of course, the platform I was using until then wasn’t WordPress, but ExpressionEngine, which afforded me a lot of template flexibility so that I could simply have EE generate the posts which I then saved to my hard drive. One at a time.

    A project of months.

  5. CGHill »

    1 March 2015 · 4:48 pm

    WordPress, I suspect, is designed to discourage you from migrating to something else.

    I did once consider adding all the Vents (then about 700) to the database. I figured this would take the better part of three months to complete.

RSS feed for comments on this post