NOTE: Importing the SQL file to your database will overwrite your existing content and website settings. DO NOT import the SQL file if you want to keep the existing content
NOTE: ALWAYS backup your database before performing any modifications
How to install a template with sample content on Drupal 6.x.
1. All the core modules, except for the "OpenID", should be enabled here in order for the database import process to run smoothly.
Go to "Administer -> Site Building -> Modules" to enable them.
Installing additional modules (if they are included in the template package):
2. Uncompress the module files with your favorite unzipping program.
3. Upload these modules to "/sites/all/modules" directory on the server using your file manager or FTP program. If you don’t have the "modules" folder in "sites/all", create one first.
4. Enable these modules in "Administer -> Site Building -> Modules".
5. Upload your theme folder to "sites/all/themes" directory. If you don’t have the "themes" folder in "sites/all", create it.
6. Go to "Administer -> Site Building -> Themes". Find the uploaded template in the list and set it as default.
Importing the SQL file.
7. If you are using a tool like phpMyAdmin:
a) select your site’s database;
b) click the "Import" tab at the top;
c) browse to the SQL file from the sources folder.
d) press "Go".
NOTE: After this is done, all the current content on your site will be replaced with the sample content.
6. Open "YUI Common Settings" and type the path to your theme in the "Location of YUI library" field.
If you uploaded the template to "sites/all/themes", then the path will look like:
sites/all/themes/yourtheme
(change "yourtheme" to the actual name of the theme folder).
Feel free to check the detailed video tutorial below: