Aug 132014
 

All In One WP Security And Firewall Database Security helps you setup the database security, change db prefix, create database backups and more.

Last Updated: June 3, 2018

Latest News: I have improved the wording and adding more information.

It is very important to create a database backup of your site. AIOWPS has the feature needed for this. Once you install AIOWPS plugin, the first step you need to take is to create a database backup. Anything goes wrong from here on and at least you will be protected and you will be able to restore your site through the database you create in this step.

Note: Make sure you read and follow these steps carefully.

All In One WP Security And Firewall Database Security

Step 1 ) Click on the WP Security -> Database Security to set up the following security settings. See images below.

Enabling this feature will give you another  10 points score towards your security meter. See images below. (Intermediate Security Level)

  • DB Prefix
  • DB Backup

all-in-one-wp-security-and-firewall-database-security

Step 2 ) Click on the WP Security -> Database Security -> DB Prefix  to set up the following.

  • Current DB Table Prefix:
  • Generate New DB Table Prefix:

Information: There is another tab Host System Logs which displays the host log files. This can be very handy to check from time to time especially when you are trying to troubleshoot a problem. 

all-in-one-wp-security-db-prefix

Step 3 ) Click on the WP Security -> Database Security -> DB Backup to set up the following. You can create a Manual Backup or set up Automated Scheduled Backups and gain 20 points score towards your security meter. (Basic Security Level)

Database Backups

  • Click on Create DB Backup Now button to create a manual database. Click on the following URL test-your-wordpress-site-locally to learn how to backup your database. (Note: This tutorial is based on Xampp, however the steps carried out are similar and or identical to the steps carried out in a live server.)
  • Enable Automated Scheduled Backups:
  • Backup Time Interval:
  • Number of Backup Files To Keep:
  • Send Backup File Via Email:

Important: If you are creating an automated scheduled backup please read solution 14 in the following URL All In One WP Security And Firewall Troubleshooting.

all-in-one-wp-security-backup

Note: If the emailed attachment always turns up as an SQL file and not a ZIP file like all the others that means that your server is not configured correctly.

(The following was quoted by Chesio in the forum)

Database backup files are zipped only if there is ZIP extension enabled in PHP, so if you are getting plain sql files by email, most likely that website has this extension disabled.

You can find whether this extension is enabled in output of phpinfo or you can create a dummy PHP file with class_exists( 'ZipArchive' ) check – this is what actually AIOWPSF plugin does.

For example:

<?php
echo class_exists( 'ZipArchive' ) ? 'ZIP extension seems enabled' : 'ZIP extension seems disabled';

=============================

Click on the following link Filesystem Security to continue configuring the plugins settings.

If you have any questions please let me know

Enjoy.

All In One WP Security & Firewall Tutorials List:

Manuel Ballesta RuizManuel Ballesta Ruiz is a web developer, Blogger and WordPress Enthusiast.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

The following GDPR rules must be read and accepted:
This form collects your name, email and content so that we can keep track of the comments placed on the website. For more info check our privacy policy where you will get more info on where, how and why we store your data.