This tutorial will show you how to install Magento theme and sample data (dump.sql file).
Create a MySQL database and database user/password for Magento. This step varies by hosting provider and is out of the scope of this document. Consult your provider’s support/documentation for instructions on how to do this. Also, you can use this tutorial on how to create a database if your hosting is GoDaddy.
Import the dump.sql file (it can be found in your template package included to the ” sources.zip ” file) into your database using this tutorial on how to import the SQL files into the database.
Please refer to your template preview page where the required version of Magento is listed under the “Technical Details” section. All other versions are not compatible with the templates sample data (dump.sql file):
Download the required version of Magento at https://www.magentocommerce.com/download under the “Release Archive” tab and upload its content to your server via FTP or FileManager of your CPanel:
Navigate to the template files directory and open themeXXX folder, where XXX is the theme number:
There you can see app, js, lib, skin folders and .htaccess and robots files:
In the Sources/sample_data folder of your template find media folder:
Upload these files and folders to your Magento installation root. You can check the following tutorial on how to upload files .
Open a web browser and type your domain name in or point your browser to the directory you extracted your files to.
You are going to see the first page of Magento installation called “License Agreement”. Select the terms and conditions checkbox and click on the continue button:
On the second page called “Localization” you are going to set default location, time zone and currency for your online shop. Then move to the next step:
At step 3 called “Configuration” you are going to see a screen asking for the MySQL database details created at Step 1 of this tutorial. This page is broken up into several different sections:
Database connection: Enter your host name, database name, user and password, and tables prefix. This can be found through your web hosting cpanel or another administrative interface:
Web access options: specify the URL of your Magento store, for example http://www.domainname.com. For Admin Path it should prefill with admin is customizable. If you have an SSL, it is recommended that you check the Use Secure URLs (SSL) box:
Session storage options: You can choose either File System or Database. Storing sessions in the database is better for security, but might cause additional load on your database. Session storage that uses File System allows easy access to session information via FTP:
When you are done, click “Continue”.
Next step is called “Create Admin Account”. You will have to type your first, last name, e-mail, username and passwords in. Magento will ask you for the encryption key as it encrypts all the data. In case you want to decrypt it, you will have to give the encryption key. Leave this field empty and Magento will use some random key for this purpose which will be given to you in next step:
As a last step, you will be asked whether you want to go to the frontend or backend:
Front-end: it is the website which will be shown to the user upon access. If you click on it, you are going to see the template looking like the live demo.
Back-end: it is your admin dashboard where you can manage your e-store.
Clear Magento cache to check the installed theme applied.
Feel free to check the detailed video tutorial below:Magento. How to install template and sample data,