O'Reilly logo

Drupal for Education and E-Learning - Second Edition by Bill Fitzgerald, James R. Robertson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Manually backing up the database

The Backup and Migrate module automates database backups for you. However, there are still times when you might want to or need to back up your database manually, such as before a site upgrade.

Before you back up your database, you should optimize the tables in the database.

Backing up the database via phpMyAdmin

phpMyAdmin has an export utility that can be used to back up your database. As shown in the following screenshot, you can access it by clicking on the Export tab:

Backing up the database via phpMyAdmin

The Export screen contains two options: Quick and Custom. A quick export will output a text representation of the database in the format you select ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required