How to Install Sample Data for Magento?
1) Download Sample Data zip file from Magento Website
2) Extract the zip file
3) Drop all the tables from your magento database. It would be easy to drop the magento database and then recreate it instead of dropping individual tables.
4) Import sample data sql file into your magento database.
# Remember that, you have to drop all tables from your magento database before importing the sample sql file. You will get error afterward if you import the sample data without dropping tables from your magento database. Therefore, step 3 is important.
5) Go to your magento installation folder and delete local.xml file present inside app/etc folder.
6) Reinstall magento.
# After you installation is complete, you may get error something like this:
Integrity constraint violation: 1062 Duplicate entry ‘1′ for key 1
Clear your browser cache or open your website in another browser and you are done 
Related posts:
Leave your response!