Backing up your site is good.
Automatically backing up your site is better.
Automatically backing up your site to somewhere easy to use like Dropbox.com is the best.
Wordpress Backup to Dropbox is simple plugin that will automatically backup your WordPress site to your Dropbox account. Here's how it works:
Before You Start
You're going to need two things for this tutorial:
Step 1: Install the plugin.
Step 2: Authorize the Dropbox connection
Step 4: Configure your backups
Step 5: Make the first backup
Before we leave this plugin to run, we're going to test that it works.
Step 6: View your backup files on Dropbox
Step 7: Schedule routine backups
For your automatic backups, you can set a day of the week as well as a frequency schedule.
Setting the time for the backup is also an option but it could be a little deceptive. The backup process only starts when someone visits the website, so if you have the process set for 1 a.m. and nobody visits your site until 6 a.m, the backup will be 5 hours late.
If you are running periodic backups, be sure to frequently check in on your History to see if there are any error messages. If you find errors and something hasn't been loaded, you may have to manually upload or backup that file.
Once your files backup are completed, you only need to move those files back to your server to put them back on your site.
Your database backup is a little different. The program will store the file on the server with the extension .sql. Files ending in .sql it needs to be imported into your database, often via software called phpMyAdmin. The database is backed up into a file named '[database name]-backup.sql'. It will be will be found at the path 'wp-content/backups' within the App folder of your Dropbox.