2

I tried to upload product through magmi. After run import i got an error

enter image description here

SQLSTATE[HY000] [2002] Connection timed out

How can i fix this

Improve this question
7
  • Does the import fail immediately or partway through the import? – MartyS Sep 18 '16 at 13:16
  • it's failed means not import single product also – Magento 2 Sep 18 '16 at 15:54
  • restart mysql at server and also check your credential in magmi and try again – Murtuza Zabuawala Sep 19 '16 at 3:50
  • I done restart my sql still same error – Magento 2 Sep 19 '16 at 17:32
  • 1
    If your magento store is working properly then you have entered the database credentials wrong in the magmi profile – Goku Sep 21 '16 at 5:18
2
+25

If you are using a local socket then you should specify that you are using a socket under connectivity other wise you will have to add a tcp route such as localhost or an ip address such as 127.0.0.1
enter image description here

Improve this answer
0

This is the error because the magmi importer has timed out while uploading data to your database. You can ask your hosting providers to increase the maximum timeout of your sql database and increase maximum memory.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.