Having a current backup of your customer’s WordPress website hosted by you is critical for protecting their websites against disastrous data loss or corruption initiated by the top 5 security issues in WordPress. There are two parts to back up an entire WordPress Site: Database (MySQL database) and Files. With Ahsay backup solution, you are just 2 simple steps away from completely safeguarding your customers’ WordPress sites.
WordPress MySQL database backup
On AhsayOBM client backup application, create a MySQL database backup set (free add-on module) to back up your customer’s WordPress database. After proper configuration, the database will be backed up to your selected destinations, such as your AhsayCBS backup server, local storage or public cloud storage, according to the defined backup schedule.
WordPress site files backup
Even if hackers, server crash or user errors completely wiped out your customer’s WordPress sites, you can still quickly restore their most recent WordPress database and files from the secure backup destination with ease.
How it works
Suppose you have your own AhsayCBS backup server up and running, and AhsayOBM client backup software installed on your web server that has WordPress and MySQL database running on it. All you need to do is to create 2 backup sets mentioned previously.
For example, I have a WordPress site, My Ahsay Blog, with site files installed on D:\wordpress. I have create a database called “blog” in MySQL for storing WordPress data.
Let’s see how to back up this site.
Create a backup set for backing up WordPress MySQL database
Login to your AhsayOBM client software, click on the Backup Sets button.
Create a MySQL Backup Set. Enter the MySQL login info and the path to your mysqldump.
Select the WordPress database node.
Setup the backup schedule for automated backup. Here, I created 2 daily backups. If the site has content updates frequently everyday, then you can create more frequent scheduled backups.
Setup the backup destination. For demo purpose, I just set AhsayCBS backup server as the only destination.
Keep the default encryption settings.
Copy the encryption key and save it securely so that when you need to restore the backed up data on another machine, you will need to enter the encryption key then.
That’s it. The backup set for backing up WordPress MySQL database is created. Click on the “Backup Now” button to fire a backup to AhsayCBS manually.
Done. The selected MySQL database is backed up to AhsayCBS successful.
Next, we need to create a File backup set for backing up WordPress site files that are stored in D:\wordpress.
Also, I will back up my PHP (php.ini) and Apache configuration files so that in case my PHP or Apache has problem, I can restore those configurations after re-installation.
As these files update frequency is lower, once per day backup is good enough. Don’t worry that it will backup all the files everyday. After the initial full backup, AhsayOBM won’t backup those files which have not been modified.
Set AhsayCBS as the backup destination for this backup set.
Keep the default encryption settings.
Done. Backup set created. Fire a backup manually by clicking the “Backup Now” button.
All site files, PHP and Apache configurations have been backed up to AhsayCBS backup server.
Restore WordPress MySQL database if user accidentally deleted contents
Let’s see how the restore works. Assume the WordPress editor has accidentally deleted all the site posts, we can easily restore them back to the WordPress site by restoring the backed up MySQL database with just a few click.
Let’s delete all the posts permanently first to simulate the data loss scenario. Just go to WordPress admin section > Posts, and trash all the contents permanently.
Load the WordPress site and all the contents should be gone.
Now, open AhsayOBM and click the “Restore” button.
Select the WordPress MySQL database backup set to restore.
Select the backup destination from which to restore. Since we have just one destination, just click on that.
Select the database node, i.e. blog, to restore.
Since we want to restore all the backed up contents back to the site, we can simply choose to restore to “Original location”.
Choose a temporary directory for AhsayOBM to store temporary files during the restore process. Then, click the “Restore” button to start the restoration.
After successful restoration, go back to the WordPress admin page > Posts. All the contents should be reappeared.
Reload the site and all the contents should be restored successfully.
Sounds good? Just drop us a message if you want to offer WordPress backup solution to your customers.