As a web designer and developer, I feel it is important to provide my clients with daily backups of their websites.
Knowing how to backup your website files, and knowing how to backup your WordPress database are not the same thing. The database is not included in your files. It resides in a separate location on the server and must be backed up separately. I had a customer who wanted me to move their existing blog to my web hosting service, they provided me with a copy of their files, when I explained to them that I needed a copy of the database, they were surprised. They had no idea that the database was not included with the files.
Automatically Backup Your WordPress Database
Fortunately there is a plugin that will automatically backup your WordPress database. There are several plugins you can use to backup your WordPress database, but the one that I use is called WP-DBManager. I install it on every WordPress blog that I develop, and you can use it to easily backup your WordPress database
I like WP-DBManager because it does a lot more than backup your WordPress database. It also allows you to optimize, repair, and restore your database. Perhaps the most important feature is that you can set automatic scheduling of your backups, and have a copy of the database emailed to you!
I have a copy of my database sent to my Gmail account daily. I have created a filter for these mailings, they are automatically archived instead of arriving in my in-box, this way I never see the email, but I know that the backup is there if I ever need it.
Instructions For Installing WP-DBManger
Installing this plugin is a little more complicated than installing other plugins. There are some files that need to be renamed and moved. It takes a little extra work but is well worth the effort, and it will allow you to backup your WordPress database automatically.
- Install and activate the plugin
- The script will automatically create a folder called backup-db in the wp-content folder if that folder is writable. If it is not created, please create it and CHMOD it to 777
- Using your FTP program, or File Manager, Open the wp-content/backup-db folder
- In the wp-content/backup-db folder rename the htaccess.txt file to .htaccess
- Move the .htaccess file from: wp-content/plugins/wp-dbmanager to wp-content/backup-db
- Login to your WordPress Admin Dashboard, Go to ‘Database -> DB Options’ to configure the plugins options. This is where you can set the frequency of the Automatic Scheduling of your Database Backups, and the Automatic Scheduling of your Database Optimization.