Live site DB import into localhost wamp server, its return

Script timeout passed, if you want to finish import, please resubmit the same file and import will resume.

Error : enter image description here

How can i solve this error?

My DB Size : 1.4GB

closed as off-topic by Siarhey Uchukhlebau, sv3n, liyakat, Moose, Fabian Schmengler Jun 29 '17 at 6:38

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions describing a problem that can't be reproduced OR seemingly went away on its own (or went away when a typo was fixed) are off-topic as they are unlikely to help future readers." – Siarhey Uchukhlebau, sv3n, liyakat, Moose
If this question can be reworded to fit the rules in the help center, please edit the question.

  • I'm voting to close this question as off-topic because importing large DB dumps into phpMyAdmin is not specific to Magento – Fabian Schmengler Jun 29 '17 at 6:38

Try to import via CLI. Use this command:

mysql -u username -p database_name < file.sql

If your mysql database is very big, you might want to compress the output of mysqldump. Just use the mysql backup command below and pipe the output to gzip, then you will get the output as gzip file.

$ mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]

take backup and restore

gunzip < output.sql.gz | mysql -u username -p password database

  • not working ... i tried already – user51361 Jun 28 '17 at 9:09
  • compress using command line restore – Rama Chandran M Jun 28 '17 at 9:17
  • actually, i compressed my DB as a name.sql.dz still not successfully import. – user51361 Jun 28 '17 at 9:23
  • Hw can i run this, could you pls sent screen shots :: gunzip < output.sql.gz | mysql -u username -p password database – user51361 Jun 28 '17 at 9:27