Book Image

Drupal for Education and E-Learning

Book Image

Drupal for Education and E-Learning

Overview of this book

Table of Contents (22 chapters)
Drupal for Education and E-Learning
Credits
About the Author
About the Reviewers
Preface
Index

Caring For Your Database


The database containing your site's data is the single most important piece of your site. It contains all of the configuration options you have put into your site, as well as the countless hours of work completed by your students. In short, it needs to be treated with care. Taking care of your database ensures that your site will run smoothly over time.

As you use your site, your database tables will benefit from optimization. This step, although not technically necessary in most cases, can help prevent errors over time. Optimizing tables can be compared to giving a car a tune-up, or with defragmenting a computer's hard drive.

Table optimization can be automated by using the DB Maintenance module, but if you choose not to use that module you have other tools at your disposal.

Using PHPMyAdmin as a Maintenance and Backup Tool

PHPMyAdmin comes with some useful, browser-based tools for backing up and optimizing your database.

Optimizing Tables Using PHPMyAdmin

As pictured...