How to Install Automated MySQL Database Backups in Drupal 8

How to Install Automated MySQL Database Backups in Drupal 8

 

Introduction: Drupal 8 File & Database Backup Automation

This Tutorial will guide users to set-up an automated MySQL database backup service for Drupal 8 websites using the Backup & Migrate module & options for off-site file storage. Some of the advanced functions like NodeSquirrel & Dropbox are D7 only.

Drupal 8 administrators can choose to make a complete site file backup, a copy of the files saved by the CMS outside of Drupal 8 core, or the MySQL database export.

The Backup & Migrate module allows MySQL database backups for a Drupal 8 site to be scheduled on an hourly, weekly, or monthly basis according to owner requirements.

Step One: Install the Backup & Migrate Module for Drupal 8

To get started, download the Backup & Migrate module from drupal.org & install the files at admin/modules/install or use your choice of FTP, Git, Drush, etc. to accomplish the task according to standard web development practices for your project or team.

Required Modules – Download:

Configuration: Enable the module & save the settings. It is recommended to take the Drupal 8 website offline for maintenance when installing the modules manually.

Place the website in maintenance mode at: admin/config/development/maintenance when working with the database backup system or installing new modules.

Step Two: Configure the Settings for Database Backups

After the Backup & Migrate module has been installed, navigate to: admin/config/development/backup_migrate & review the configuration settings.

How to Install Automated MySQL Database Backups in Drupal 8

On the Quick Backup page, Drupal administrators have the choice to manually download the MySQL database, site file, public file directory, or the entire website.

How to Install Automated MySQL Database Backups in Drupal 8

On the Advanced Backup page, Drupal administrators have a wide range of settings to choose the compression standard or exact tables to be downloaded from the database.

Either of these pages can be used to complete a Manual Download of a MySQL Database to a desktop computer or remote file as a backup or reference file.

Step Three: Scheduling Regular MySQL Database Backups

Scheduling regular MySQL Database backups for a Drupal 8 website can be accomplished using the Backup & Migrate module under the Schedule section.

Navigate to: admin/config/development/backup_migrate/schedule and click on the button to “Add Schedule”. Give the schedule a name and review the site configuration.

How to Install Automated MySQL Database Backups in Drupal 8

Choose “Default Drupal Database” for the backup source and the Private Files Directory for the backup destination. Then choose to backup the database on a hourly or daily schedule according to the requirements of your website content & traffic.

High traffic websites can save backups on a minute-by-minute basis to guarantee the latest changes from users are saved in emergencies. Static websites may only need a weekly or monthly backup. Save the number of files to keep according to this aspect.

It is recommended to keep 10 to 100 database backups in the Private Files Directory depending on your storage capacity & need for security, where only the last is valid.

Step Four: Uploading MySQL Database Files for Restore

If your Drupal 8 website goes offline, gets hacked, or crashes for unknown reasons, the main advantage of the Backup & Migrate module is the previous version can be restored. Navigate to the Public Files Directory & download the latest MySQL file.

How to Install Automated MySQL Database Backups in Drupal 8

Navigate to admin/config/development/backup_migrate/restore and upload the MySQL Database file from the backup folder. This will completely replace the current database.

Developers can use the Backup & Migrate module to port Drupal 8 databases between environments. The backup MySQL files are an essential part of restoring Drupal 8 websites under emergency situations, hardware crashes, or human error.

Step Five: Working with phpMyAdmin & cPanel Tools

Some of the MySQL Database backup & restore functionality is reproduced in phpMyAdmin & cPanel for Drupal 8 web publishers on shared Linux hosting plans.

In cPanel, look for the phpMyAdmin icon and click on the link to open the application. All of your domain name MySQL Databases can be administered through the software.

How to Install Automated MySQL Database Backups in Drupal 8

Click on the link for your Drupal 8 database in phpMyAdmin, then click on the “Export” tab. There are settings for a Quick & Custom export depending upon the requirements.

Use the Advanced Settings page with phpMyAdmin defaults to export the Drupal 8 database with utf-8 as standard. Additionally, check the box for the following rule set:

Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGERstatement

Although the phpMyAdmin database export files are not compatible with the MySQL Database backup files generated by the Drupal 8 module, both can be used as required in development & production to build a competent data security system.

Note: cPanel’s Backup Manager is another option on some shared Linux plans, but does not have the flexibility to set scheduled MySQL Database backups for Drupal 8.

Conclusion: Essential for Drupal 8 Website Management

The Backup & Migrate module for Drupal 8 is an excellent tool for scheduling automated MySQL backups on a regular time intervals, robust enough for enterprise traffic levels. Schedule Database Backups by second, minute, day, week, & month.

Use the Backup & Migrate module with phpMyAdmin to restore Drupal 8 websites to previous versions or when changing web hosting companies and moving files to a new web server. Keep backups in case of any crash of hardware or software malfunction.

Check out these top 3 Drupal hosting services:

Kamatera
$4.00 /mo
Starting price
Visit Kamatera
Rating based on expert review
  • User Friendly
    3.5
  • Support
    3.0
  • Features
    3.9
  • Reliability
    4.0
  • Pricing
    4.3
Hostinger
$2.99 /mo
Starting price
Visit Hostinger
Rating based on expert review
  • User Friendly
    4.7
  • Support
    4.7
  • Features
    4.8
  • Reliability
    4.8
  • Pricing
    4.7
Ultahost
$2.90 /mo
Starting price
Visit Ultahost
Rating based on expert review
  • User Friendly
    4.3
  • Support
    4.8
  • Features
    4.5
  • Reliability
    4.0
  • Pricing
    4.8

How to Install MySQL on a Windows Web Server Running Apache

This tutorial will show you how to install the MySQL database on a Windows serve
3 min read
Michael Levanduski
Michael Levanduski
Expert Hosting Writer & Tester

How To Install MySQL on Windows

This how-to article teaches you how to install MySQL on Windows.
4 min read
Avi Ilinsky
Avi Ilinsky
Hosting Expert

How to Move Your WordPress Site from Your Local Web Server to Your Live Site

You can always accelerate the development process by developing your WordPress s
4 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO

How to Disable MySQL 5 "Strict Mode" on an Ubuntu 18.04 VPS or Dedicated Server

How to Disable MySQL Strict Mode on MySQL 5.6 Running on an Ubuntu 18.04 VPS.
2 min read
Idan Cohen
Idan Cohen
Marketing Expert
HostAdvice.com provides professional web hosting reviews fully independent of any other entity. Our reviews are unbiased, honest, and apply the same evaluation standards to all those reviewed. While monetary compensation is received from a few of the companies listed on this site, compensation of services and products have no influence on the direction or conclusions of our reviews. Nor does the compensation influence our rankings for certain host companies. This compensation covers account purchasing costs, testing costs and royalties paid to reviewers.
Click to go to the top of the page
Go To Top