Announcing DBC Backup 2, a WordPress plugin to backup your WordPress SQL database is now available from WordPress Plugins.
DBC Backup 2 creates a SQL export and saves a compressed file to your web host server. Many web hosts provide large amounts of free space for storing your data so it makes sense to use this free space to safely store your database.
- Save time - set a Batch Job to run daily, weekly, monthly
- User Control - User defined path to store backups
- Compact - Compression of SQL exports (Gzip or Tar) saves space
- Safe - the export folder is ‘protected’ from prying eyes or direct downloads
- Save money - Uses web host to store export backups
Revival of DBC Backup
The plugin is a revival of a much older plugin that I have used for a couple of years now. If the original developer gets in contact, I’d be happy to share the SVN repo keys.
- Upload the plugin dbcbackup to the `/wp-content/plugins/` directory
- Activate the plugin through the ‘Plugins’ menu in WordPress
- Go to the Settings page ‘DB Cron Backup’ from the main men.
- Configure the plugin settings and you are ready. You’ll need to know your server path to a folder you want the backup saved.
- If the plugin can’t create the export directory you will have to do it manually and don’t forget to chmod 777 it.
- If you are upgrading, deactivate the plugin first and remove all old files, before starting.
Frequently Asked Questions
Why create a server based back-up?
It makes sense to me to keep the SQL database backup where you will most likely need it if something goes wrong. Many web hosts provide a large amount of free space for you to store files. So rather than having to pay someone else for storing your database backup you can use the free space you already have.
Aren’t server based back-ups insecure?
Not really, server based back-ups are only unsafe if your server is prone to fail or poorly protected from hacking.
I want to make my backup more secure
That’s easy, the plugin creates a .htaccess file in the backup folder. You can open this file and add to this code. The backup folder is protected against browsing or direct file access.
Does The plugin takes a backup whenever I setup a specific cron job
If the time of the cron is before the current time the wp cron system is adding the cron job to run at the next page view, despite how long ago it is set.
Why don’t any compression formats appear?
Because Gzip and Bzip2 are not installed on your server.
Does this work for multisite?
Yes if you are site admin then each site can run its own version of the plugin and backups of the SQL database can be created.
Read more from my blog for an introduction and quick tips on developing in Hugo or UCTD.