Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you are a premiere member of lynda.com Online Training Library or if you are watching this tutorial on a DVD-ROM you have access to the exercise files used throughout this title. There are two kinds of exercise files. The first is the database file. Each video has its own database file, which is installed using the program phpMyAdmin. On the Mac you open phpMyAdmin by going to MAMP and then clicking on the Open start page button. From there you click on phpMyAdmin. If you are using a PC with WAMP you can get there by clicking on the WAMP icon in the System Tray and then going to phpMyAdmin.
Once there, you will have to delete your existing database if you already have one loaded. I should warn you though this will completely remove your Drupal site. It will destroy the database that you already have. So be sure that you back it up if you haven't done so already. You can learn how to do to that in the course Drupal Essential Training. To drop your database and prepare to import a new one, go to the Databases link on the main page of phpMyAdmin. From there check the box next to the database which we have named "lynda" and then go down to this little icon which drops the database. Click it and it will ask for a confirmation. You then click Yes to drop the database.
To then import the database that you want to use, you click on the Import tab at the top of the screen. You browse for the file, which will be inside a folder called exercise_files. Inside that folder, there is one folder for each chapter in the course. Inside those Chapter folders are the individual SQL files. For this course, due to the amount of modules that need to be installed and setup as well as the ever-changing nature of these modules, we have only provided the initial database file of content to setup this course.
Click on it once and then click on Open, then go the bottom right-hand corner and click Go. If the import worked properly, you'll see a success message at the top of the screen. You can confirm that by opening up a new window and going to local host. If it shows the site the way that you expect it to look, then you have succeeded. The Drupal Username and Password throughout this course is always the same. The Username is admin and the password is booth. You should then be able to login to your Drupal site as the administrator.
In addition to the database files there is also a file folder labeled "graphics". You could learn how to use these graphics with your Drupal site from the video Including Images As CCK Fields, which is part of this series. There is one final step you may need to take. I'm recording this series using Drupal 6.10. But Drupal gets frequent updates. So there is a good chance you are using Drupal 6.11 or 12 or whatever. If there was a change in Drupal's database structure between updates you may find your Drupal installation acting strangely. So, if you are using a Drupal version after 6.10, go to your address bar and type update.php after the domain name. I'll demonstrate that.
Our domain name is localhost. Just type update.php and hit Return. You will then be led through the procedure you need to follow in order to update your database. At the time that you watch this course, these modules will have been updated as well Drupal itself, so always make sure you install the most current version. If you don't access to the exercise files, you can follow along from scratch or use your own assets. Let's get started.
Get unlimited access to all courses for just $25/month.Become a member
58 Video lessons · 66371 Viewers
61 Video lessons · 96840 Viewers
56 Video lessons · 110534 Viewers
82 Video lessons · 105174 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.