The ABC of Creating Reliable Backups in Drupal

The ABC of Creating Reliable Backups in Drupal

Find some useful tips on Drupal website data security from our guest blogger Jack Dawson, founder of Big Drop Inc.

In Drupal web development, there are a number of things that can be done to ensure the superior user experience and consistency, as well as save time and pain for the webmaster in times to come. First, you’ll need to have in mind the theme structure of Drupal and how you intend to draft your content in order to take advantage of Drupal’s best aspects and make the site efficient.

As a CMS, Drupal provides a host of advantages, especially as relates to the flexibility, allowing you to customize virtually everything about the site design. While this is great, it would all go to the dogs if you forget the most important aspect of running a Drupal site: regular and consistent backups.

According to research last year, hackers penetrated around 30,000 websites daily. That’s scary, right? You can believe that this number is even more today. Post-hacking, not all affected websites end up losing their data. As a matter of fact, hacking is just one among many ways website data can be lost, including corrupted hard drives, botched updates, server hiccups and human errors among others.

Whether for migration or just to be safe, you must have a robust plan to back up your Drupal site consistently. In this article, we’ll discuss how this can be done manually and then automatically.

Backing up Drupal manually

There are two parts to your Drupal site: the database and the files, which are what you’ll be backing up. File backup is very straightforward, you only need to:

  • Run your preferred FTP client to access your hosting server
  • Download your Drupal directory and save it to a safe location – use a cloud solution for added safety, such as your Dropbox account for individuals/smaller businesses or full-scale cloud services for large enterprises. The FTP manual can direct you if you’re unfamiliar with the process

To backup the database itself, which stores your configurations, settings and content, you’ll do it using phpMyAdmin. The steps are given below:

  • Gain access to phpMyAdmin from the cPanel
  • Choose the database to back up from the left-hand menu by clicking on it. This opens all tables found in the database
  • On the top menu, click “Export”
  • Click Custom – "display all possible options” which offers further options. Ensure you have selected all tables.
  • Mark the box with “Add DROP TABLE/VIEW/PROCEDURE/FUNCTION/EVENT statement” which is found under “Object Creation Options”. This configures existing tables to be automatically replaced on database import
  • Select “Go” to save the database in a cloud location of your choice.

Backing up Drupal Automatically

Manual backup is not only time-consuming, you cannot guarantee that you’ll always have the time and/or presence of mind to consistently back up every few days. Luckily, Drupal provides for automatic backup through the use of modules.

The leading module used by more than 250,000 websites today is the Backup and Migrate module. It supports a host of backup storage destinations including FTP, DropBox, email, Amazon S3 etc. You can also schedule multiple backups, exclude tables and restore databases among many other useful backup applications.

In conclusion, remember that this module doesn’t backup files, only the database. However, you can install a different module for file backup. For best results, Backup and Migrate should be used with a cloud storage service like Amazon S3 which is provided for out-of-the-box, or Dropbox, for which an additional module is required.

6 votes, Rating: 4.8

Read also


Imagine all website issues solved in a blink of an eye - you can just sit in a comfortable chair, have a cup of coffee and enjoy reading nice news. Yes, it’s possible. It’s not magic...or maybe...


Any developer worth his salt will tell you that the success of a website will depend a lot on the software tools used to develop it. Not all tools used in...


Mobile application development is a relatively new area of Drupal development services, but it is advancing rapidly,...


Drupal module development offers us a lot of opportunities, and today I would like to tell you about a...


Drupal and WordPress are very popular content management systems for website development. Each CMS has a passionate army of its own fans...

Subscribe to our blog updates