Installing Magento Sample Data

Magento provides sample data you can optionally install to give you an idea of what products look like in the Admin Panel.
You can use this sample data to learn how Magento works and to experiment with custom themes.

Note : You must install sample data on the file system and in the database before you install Magento.

Important: Only if your database is shared between more than one Magento installation. Database table names used by the sample data are not configurable. To use sample data with a new Magento installation, you must manually add a prefix to all sample data tables and use the same prefix when you install Magento.

Steps to be followed

1. Download the sample data from the mentioned links version 1.9 and version 1.6, 1.7 &1.8

2. Upload the files into your server and extract the sample data archive to a directory other than your Magento installation directory.

3. Upload the files into your server and extract the sample data archive to a directory other than your Magento installation directory.

4. Make note of the path to the sample data’s media subdirectory.

5. Connect the server through putty or any other terminal window application using your hosting account credentials. Change to the [your Magento install dir]/media directory.

#Ubuntu example
cd /var/www/magento/media

#CentOS example
cd /var/www/html/magento/media

6. To work with Data, loggedin user should have write permission on the corresponding directory, copy the sample data’s media directory and subdirectories to your Magento installation directory.

For example, to copy Magento sample data from /home/username to the directory(folder) /var/www/magento, the command should be

cp -R /home/username /var/www/magento

then press enter

In step-5 you have navigated to media folder so the command you need to enter is

cp -R /home/username/media/* .

7. Magento CE 1.9 and Magento EE 1.14 only.
You must also copy the sample data’s skin directory to
[your Magento install dir]/skin as follows:
For example, to copy Magento skin files from /home/username/skin to /var/www/magento/skin, enter

cd [your Magento install dir]/skin
cp -R /home/username/skin/* .

8. Import the CE or EE sample data into your MySQL database as follows:

mysql -u root -p magento-db-instance-name < path-to-sample-data-extract-dir/sample-data-filename.sql

#EE 1.13 example

mysql -u root -p magento < /home/username/magento_enterprise_sample_data_for_1.12.0.0.sql

Leave a Comment