Magento – how to import sample data of magento 1.9 in PhpMyAdmin

ce-1.9.0.1PHP

Hi friends i am new to magento and i am trying to import a sample data of magento 1.9.0.1 but i am getting the following error : 

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

Please help me to import the data in PhpMyAdmin and thanks in advance for your answers and suggestions Thanks a lot

Best Answer

The db dump for the 1.9 sample data is about 10M.
Either change the value of upload_max_filesize from php.ini to something bigger than the file size, or you can import the file using the command line: 

 > mysql -u {username} -p your_db_name < magento-sample-data-1.9.0.0\magento_sample_data_for_1.9.0.0.sql

If you are not using a passowrd for your mysql server you can remove the -p.

Related Topic