If you manage a standard wordpress infrastructure ,where you have an installation of a wordpress blog and you have two layers separated , the database layer (in my case mysql) on the database server , and other layer for the presentation (web server) that stores the images uploaded , the themes , and the scripts , you should be aware of the backup process on these two separate layers.
Backup Database file on the database server
There is an easy way and the one i recommend , and is by using the wp-db-backup plugin that you can find here , this plugin actually make a scheduled backup of your wordpress database , you chose monthy , weekly or dayly , also you can chose the backup to be sended by mail witch is very helpful.
The problem with this configuration is that you only have the backup of the database , and the database is not everything concerning wordpress contents, you should also backup the pictures of your blogs , the themes , the uploaded files and adittional scripts.
There is already a workaround to backup ALL your content on the cloud using Amazon S3 services on site http://www.wordpressbackup.org/ which is good but you have to pay for the S3 services processing.
Combine wp-dbbackup plugin + Dropbox cloud services + Windows Task Scheduler
A free alternative i propose is by using the wp-dbbackup plugin along with the DropBox API.
For that i created a c# application(that you can download below) that do the follwing:
1.Zip the contents of the wordpress Images (optionally i can especify the scritps folder but my interest relies only on the images folder for now).
2.Using DropBox API with the SharpBox libraries and a DeveloperKey (that you can obtain here ) and upload the zipped file to my free DropBox account.
3.Create a Task on the Task scheduler of Windows to execute the program every week.
You should note that i did not mentioned wp-dbplugin here , well, that is because the wp-dbplugin just works nice , and i will “improve” this solution by adding the C# program that backups the images folder of the wordpress webserver content.
This solution is free and is automated so you have an easy way to backup your wordpress solution easily.
Because DropBox is free it gives you 2gb of free space , making a weekly backup of your wordpress images folder can fill that space very quickly . You should check weekly your DropBox backups and delete old backups to prevent getting out of space.
You can download the source code below: