Database Security and Backups with All In One WP Security & Firewall

Posted OnSep 18, 2014     CategoryPlugins     CommentsNo comment

In this section of the guide to the All In One WP Security & Firewall plugin, we will take a look at Database Security and Backups.

Step 1) Login to the WordPress Dashboard.

Step 2) On the left-hand sidebar of the Dashboard navigate to WP Security -> Database Security.

km-wp-all-in-one-dbase-01

Your WordPress Database is the most important asset of your website because it contains a lot of your site’s precious information. The database is also a target for hackers via methods such as SQL injections and malicious and automated code which targets certain tables.

The options on how to secure your WordPress Database are shown below.

Note: Before setting any of the options, back-up your database.

  • DB Prefix

    One way to add a layer of protection for your database is to change the default WordPress Database prefix from wp_ to something else which will be difficult for hackers to guess.

    A. Security Points Buttons The Intermediate button displays the Feature Difficulty.

    The 0/10 button displays the Security Points assigned to this. Since there are no options selected yet, the security points are set to 0/10.

    B. Current DB Table Prefix: Ths indicates that the prefix for your database is the one WordPress assigned to it during the installation process wp_.
    C. Generate New DB Table Prefix: For this option, you can place a check mark in the check box if you want the plugin to generate a random 6 character string for the table prefix OR you can enter your own prefix in the text box.

    km-wp-all-in-one-dbase-02

    Once the settings have been selected and the Change DB Prefix button is clicked, the security points should now be 10/10.

  • km-wp-all-in-one-dbase-02a

  • DB Backup

    We recommend that a back-up of your database is created before activating any security options.

    A. Create DB Backup Now Button Clicking this button creates a backup copy of your database and places a copy in the wp-content/aiowps_backups/ folder for safe-keeping. If you have enabled Send Backup File Via Email then the back-up copy will be emailed to you.
    B. Security Points Buttons The Basic button displays the Feature Difficulty.

    The 0/20 button displays the Security Points assigned to this. Since there are no options selected yet, the security points are set to 0/20.

    C. Enable Automated Scheduled Backups: Place a check mark in this check box if you want the system to automatically generate back-ups periodically based on the settings below.
    D. Backup Time Interval: Click the down arrow to the right of the dropbox to view the available options:
    – Hours
    – Days
    – Weeks
    Select an option and enter a value in the text box. The default value is 4 Weeks.
    E. Number of Backup Files To Keep: Enter the number of back-ups to keep in the text box. The default value is 2.
    F. Send Backup File Via Email: Place a check mark in this check box and enter and ensure that a valid email address has been entered in the text box if you want the system to email you the backup file after a DB backup has been performed.

    km-wp-all-in-one-dbase-03

    Once the settings have been selected and the Save Settings button is clicked, the security points should now be 20/20.

    km-wp-all-in-one-dbase-04

The next step in the guide will focus on the Filesystem Security feature.

 


Leave a Reply

Your email address will not be published. Required fields are marked *

Send this to friend