Join Tom Geller for an in-depth discussion in this video Moving databases using phpMyAdmin, part of Drupal 7 Advanced Training.
- View Offline
As you know a Drupal site comprises two parts, files and a database.…Anybody who uses a computer is used to transferring files, but databases are a different breed.…They are basically text files that the database program MySQL reads and writes.…There are two basic ways of examining, affecting, and moving these files through…a graphical program such as phpMyAdmin, which we'll look at in this video, and…using the UNIX command-line interface, which we'll look at in the next video.…There is actually one other method using the Drupal Module backup in Migrate.…
You'll get more information about it in the videos in the section, Keeping Your…Site Safe and Secure.…But anyway, let's get back to phpMyAdmin.…You're already familiar with it if you used the Acquia Dev Desktop program…to develop your site. I'll switch to it,…so you can see how it works there.…You simply click Manage my database, and there you go.…Over in the left we have a list of all of the databases that are running on MySQL.…In fact, only two of these are Drupal sites, lynda and acquia_drupal…
Drupal 7 Advanced Training was designed as a follow-up to Drupal 7 Essential Training and it also dovetails nicely with our other Drupal courses, such as Drupal 7 Reporting and Visualizing Data and Create Your First Online Store with Drupal Commerce.
- Moving a site from the development environment to production
- Hosting a Drupal site
- Moving databases with phpMyAdmin and Unix commands
- Making site administration more efficient with Drush
- Backing up site data
- Moderating comments
- Migrating from previous versions of Drupal
- Working with themes
- Creating variable layouts
- Enabling social features
- Creating an online store with Drupal Commerce