Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
At certain points in this course, you will be working on a site that's already been built or importing text or graphics into your own site. If you're a premium 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. However, there are no exercise files until late in Chapter 3 at which time you will have already installed MAMP or WAMP and the Drupal package itself. Most videos have only one exercise file, a text file that contains the MySQL database.
You install this file into your Drupal site using the utility phpMyAdmin, which is installed as part of the MAMP package for MAC or WAMP for Windows. For details on that process watch the videos Installing MAMP or Installing WAMP. If you can't install the phpMyAdmin program or choose not to, you will have to populate the database using another method, such as other MySQL utilities or MySQL's command-line interface. But we'll show you how to do it using phpMyAdmin.
To open phpMyAdmin, open MAMP or WAMP whichever you have installed on your computer. From there click on Open start page and then the phpMyAdmin link. If you have already installed an exercise file or if you started building a Drupal site you will have to drop your existing database. To do so, go over to the database pop-up menu, select Drupal and then click on Drop. It will give you a warning that you are going to destroy the entire database. Make sure that you want to do this and backup that database if you have any information in it that you'd like to keep. But we don't, so we will click on OK. The database has now been dropped.
Now we are going to import the exercise file. To do so, scroll down to the bottom of the screen where you have this choice Import. Click on it, and then go up to Choose File and click on that button. From there navigate to the exercise file you'd like to use. We are going to go to Chapter 10, the first video and import that database. We click on the File and click on Choose; scroll to the bottom of the screen and click on Go. If the database import has been successful you will see a message up here that says so. If not, you will see a message that says that. The most common problem is for getting to drop the previous database.
Now let's go back to our site and see what it looks like. We reload the page and we can see that our importation of the exercise file has been successful. Occasionally a video will have other types of exercise files. Graphics files are included whenever we add them to our sample site in the video. Of course, you are welcome to use your own. Although, I recommend you make them of the same size and file type as those provided. Text files are included whenever we create content on the site, so you don't have to do much typing. In either case, we will show you what to do with them during the course of the video.
Once again before you use an exercise file keep in mind that dropping the database deletes nearly all the content on your Drupal site, including articles you have written, blocks you have laid out and modifications to the sites designed. If you have created anything that you want to keep be sure to backup the database first. We will show you how to do so in the video backing-up your Drupal site. If you are a Monthly Subscriber or Annual Subscriber to lynda.com, you don't have access to the exercise files, but you can follow along from scratch or with your own assets.
Now that you can find and load the example files you will move through the course more quickly and completely. Refer back to this video, if you have any problems and just to reiterate watch the session about backing up a site and restoring it from backup once you start building a site whose loss would cause you problems.
Get unlimited access to all courses for just $25/month.Become a member
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.
Your file was successfully uploaded.