Can`t import magento sql database

Question

I'm trying to install Magento on a localhost, but when I try to import the sql database, it freezes. Also, i can't access phpmyadmin anymore, neither other website hosted on localhost.

I thought the file was too large, but I increases post_max_filesize and upload_max_filesize. I also increased the maxmimum_execution_time to a higher value.

I've seen that after I turn on xampp again, the database is partially uploaded, sometime with 143 queries or 200+ queries.

What should I do to upload the entire database?

Your on the right track with changing execution time, I had to change mine to a ridiculous number to get it to work and it took ages to install — CodeX
– CodeX, Commented Aug 25, 2014 at 9:59

RichardBernards · Accepted Answer · 2014-08-25 10:09:57Z

2

Try using a commandline mysql import:

mysql -p -u username database_name < file.sql

answered Aug 25, 2014 at 10:09

RichardBernards

3,0971 gold badge25 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can`t import magento sql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related