• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Tips and Tricks HQ

  • Home
  • Projects
    • All Projects
    • Simple WP Shopping Cart
    • WP Express Checkout Plugin
    • Accept Stripe Payments
    • WP Download Monitor
    • Easy HTTPS Redirection
    • WP Security and Firewall Plugin
    • WP eStore Plugin
    • WP Affiliate Platform
    • WP eMember
  • Products
    • All Products
    • Checkout
  • Support
    • Support Portal
    • Customer Only Forum
    • WP eStore Documentation
    • WP Affiliate Software Documentation
    • WP eMember Documentation
  • Contact

How to Take a DataBase Backup Using the All in One WP Security Plugin

Home » Blog » How to Take a DataBase Backup Using the All in One WP Security Plugin

Last updated: December 21, 2013





Short of a config file or two, and a couple data folders, the WordPress database contains pretty much all of the settings and content for a WordPress web site.

Everything from user data, categories, taxonomies, comments, settings, posts and more are stored in the database. It is being read from and written to regularly during normal use of the web site, and therefore is updated constantly.

It is Important to Have a Backup of the Database

Anytime WordPress is updated, or anything else significant takes place, a manual database backup should be performed. In addition, regular backups to guard against database corruption, hacking, and other causes of data loss, should be done.

Scheduled backups of the WordPress database, as well as manual backups, can be done using the All In One WP Security plugin.



Instructions to Backup and Restore the WordPress Database

Video Tutorial

Quick Steps for Performing a Manual Database Backup

First, if it isn’t already installed, install the All In One WP Security plugin like you would any other plugin.

Step 1) Click WP Security >> Database Security from the left side menu in the WordPress dashboard.

Step 2) Now from the top of the page, click the tab labelled DB Backup.

Step 3) You can now enable automated scheduled backups if you like. You can set the time interval between backups and the number of database backups to keep before overwriting them. Plus, you have the option to receive the backup by email.

Step 4) While you are in there you can run a DB backup manually. To do so, click the Create DB Backup Now button.

After clicking the button you will get a comfirmation message saying: “DB Backup was successfully completed!” The backups are stored in a “backups” folder inside the plugin’s folder.

Now you can download the database backup to your computer from the provided link. Just right click and click “Save link as…” (or a similar command) and save the .zip file to your computer. The .zip file will contain one file which is copy of the SQL in your database.

Restoring the Database from the Backup File

In the event that something goes wrong and you need to restore a previously backed up SQL file for your MySQL database, use the steps below. These steps will be performed outside of the WordPress environment so access to your web host’s Control Panel is necessary.

  1. Login to the Control Panel (CPanel) of your web host.
  2. Look for the box called Databases and click phpMyAdmin.
  3. From the left side, locate the database you need to restore and click on it.
  4. Be sure that you are on the Structure tab and scroll to the bottom of the page.
  5. Click the Check All option to highlight all of the tables.
  6. From the With Selected: drop down box choose Drop.
  7. Click the Yes button.
  8. Click the Import tab.
  9. Click the Choose File button.
  10. Locate the backup file on your computer and double click it.
  11. Click the Go button.

Now exit out of phpMyAdmin, you have recreated your database from the backed up file! Test your WordPress site to if it behaves as expected.

Recreating/Restoring the Database from Scratch

Many people like to destroy the database completely and then restore the backup SQL. If you want to go that route, be sure to have a look at the wp-config.php file in the root of the web site to check the database settings. Make note of the database name, database user name, and database password. Then use that information when recreating the database and user.

If your database was compromised however, this may be a good opportunity to use a new name for the database, a new password, and a new database user. Be sure your changes are reflected in the wp-config.php. Also, if the “MySQL hostname” in the wp-config.php file is anything other than “localhost,” you may have to reset that value after the database is created.

Once the new database is created, follow the “restore” procedure above short of dropping the tables (because the database will already be empty).

Related Posts

  • How to Easily Import or Export any of Your WordPress Database Table Content
  • How to import WordPress SQL database backup file without having ‘create new database’ privileges in phpMyAdmin
  • Database Recovery Techniques
  • All In One WP Security Plugin – Using the ‘Cookie Based Brute Force Login Attack’ Prevention Feature

Video Tutorial,  Wordpress all in one security plugin,  Database,  database import,  Database Recovery,  Security

Reader Interactions

Comments (2 responses)

  1. Myke Ngo says:
    September 1, 2014 at 2:05 am

    I am glad I found your plugin. From now on, I will install it to all my clients’ website.
    Thanks,

  2. Zach Smith says:
    July 29, 2013 at 8:47 am

    this was actually informative – not like most of what i see online. sharing 🙂

Leave a Reply

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

Primary Sidebar

Featured & Popular Articles

Video Answers to Top WordPress QuestionsWordPress Optimization Tips and Tricks for Better Performance and SpeedEssential WordPress Security Tips - Is Your Blog Protected?WordPress Simple PayPal Shopping Cart PluginTop 15 Search Engine Optimization (SEO) Techniques I Forget to DoList of the Best and Must Use WordPress PluginsHow do I Start a Blog and Make Money Online?Good Domain Name Picking Tips for Your Blog SetupFind Out Which WordPress Web Hosting Company Offers the Cheapest and Reliable Web Hosting Solution

Featured WordPress Plugins

WP Express Checkout Plugin
wordpress estore plugin
wordpress membership plugin
wordpress affiliate plugin

Recent Posts

  • How to Use Browser Developer Tools to Inspect Elements and [...]
  • Accept Donations via PayPal from Your WordPress Site Easil [...]
  • Buy Now Button Graphics for eCommerce Websites [...]
  • Subscription Button Graphics for eCommerce Websites [...]
  • Adding PayPal Payment Buttons to Your WordPress Sidebar Ea [...]

Comment & Socialize

  • @Rob, We have just released ...
    - admin
  • I installed the plugin a co ...
    - Rob
  • @Sebastian, We've released ...
    - admin
  • I've used this plugin on a ...
    - Sebastian Djupsjöbacka
  • @John, this plugin doesn't ...
    - admin

Check out our solutions

View our WordPress plugin collection and start using them on your site.

Our WordPress Solutions

Footer

Company

  • About
  • Privacy Policy
  • Terms and Conditions
  • Affiliate Login

Top WordPress Plugins

  • Simple Shopping Cart
  • PayPal Donations
  • WP Express Checkout
  • WP eStore
  • WP eMember

Blogging Tips

  • How to Start a Blog
  • Selecting a Good Domain
  • Cheap WP Hosting
  • WP Video Tutorials
  • Simple SEO Tips

Search


Keep In Touch

Copyright © 2025 | Tips and Tricks HQ