Where do you keep backups? I guess that depends on what do you backup. You might have a very clever answer for a business critical data but what about less important content? The best example would be a private blog. It will hurt if you lose your data but the odds are you're not willing to pay for any reliable storage. [...] There is one reliable storage, which is 100% free and almost everybody have access to it. Yes, I'm talking about Google Drive.

He walks you through the process of setting up your Google Drive account API access and where to find the data you'll need to make the connection. He then links over to his project that makes the backup a simple few lines of code (mostly configuration) of a backup path of your choice out to the remote Google Drive account.

As part of the backup strategy we also wanted to capture incremental versions of the documents (on a daily basis) in the event we needed to go back to the prior versions. To this affect I whipped up a small (120 lines) PHP script that will retrieve all your Google documents and save them to a local directory, in the event the document was created/updated in the last 24 hours, thus ensuring snapshot support.

His script exports each of the documents contained in the account and puts them on the local file system prefixed with a year/month/day value to keep things unique. You'll need curl and SimpleXML enabled to be able to use the script, but it's a pretty simple thing to drop in and run on most PHP5 installations.

Here's the code in raw text and syntax highlighted versions.

No matter how much you trust your hosting company, disasters happen to everyone. You might also decide to change hosts, in which case you'll need to migrate your WordPress installation. In either case, you should have a full backup of your WordPress database and files from which you can easily restore, without losing any important data.

He shows two different ways to get the job done - one, doing a manual backup, is a bit more complicated than the other method, using plugins to help out - but they both end up with the same result. For each method there's detailed instructions and screenshots (as well as links to the two plugins they chose to use).

The strategy you choose really depends on your application and your data. [...] Since I can't possibly cover everything between those extremes in one post, I'll aim for something in the middle. Like a blog, perhaps. In other words, I'll address the scenario in which I don't want to lose data, but I'm not willing to go to extremes to preserve it.

The post is largely SQL Server related - mostly for the BACKUP and RESTORE - but it gives you a good idea of how to make a full backup, take a snapshot of your logs and restoring that information back up just in case.

Tasked with building a software flight recorder for Zend Server 5.0 (the new release of its popular PHP web application server), Zend chose Adobe Flex. Join this webinar by Adobe and Zend to learn what made The PHP Company opt for Flex, see a live demo, and hear lessons learned from one PHP/Flex development project. You'll find out how Flex and PHP can be used together to enhance your application.

You can catch it at one of two times (or both if you really want to, I suppose) - February 3rd at 6am PST or February 4th at 9am PST.

They're free to attend, so stop by and see what the Zend Server software has to offer that could save you and your developers a lot of time and hassle in the future.

I often get questions about WordPress security and how best to manage WordPress upgrades. These issues are closely related, and I've thought about them a good deal over the years (and I've been doing this long enough to have experimented with a variety of approaches). These are the approaches I am currently using and recommend for the technically savvy.

For each of the three topics (security, upgrades and backups) he talks a bit about the current situation of it in the WordPress world and offers up some helpful hints to guide you along a good path as well as links to a few services and tools that can help save you when you need that all important file from a backup.

Since the previous posting, I have added a backup/restore mechanism for static attributes of classes to PHPUnit. This is yet another feature of PHPUnit that makes the testing of code that uses global state (which includes, but is not limited to, global and superglobal variables as well as static attributes of classes) easier.

Two graphs illustrate the difference - one showing a normal run and another with this new feature in use and showing off the performance increase it can give.

It is hard to test code that uses singletons. The same is true for code that uses global variables. Typically, the code you want to test is coupled strongly with a global variable and you cannot control its creation. An additional problem is the fact that one test's change to a global variable might break another test.

You can disable the backup option if you'd like by setting the $backupGlobals option in your test to false. This lets PHPUnit know that you want to leave the globals (and superglobals) alone during the run.

A simple drop in replacement function for PHPs mail() function called mailb() which backs up all the data to a specified directory. [...] I've also added a simple header file to Apache and the download directory so it looks nicer.

You can download a copy of his library here as a .phps file (a quick and easy 40ish line script).

Ever wished for an easy way to transform SQL result sets into XML? It's a PEAR package named XML_Query2XML, and it provides a comprehensive framework to efficiently turn the results of a database query into a customizable XML document. This article introduces the package, and demonstrates useful real-world applications, including using it with XSL and XPath, combining it with data from external Web services, and creating database dump files.

They go through the installation and the steps to create the XML:

• Convert SQL to XML
• Transform XML output with XSL
• Customize XML output
• Work with SQL joins
• Filter SQL records with XPath
• Merge data from multiple sources
• Create database backups

Check out the full tutorial for an excellent guide to using this powerful PEAR package.