I tried to upload product through magmi. After run import i got an error
SQLSTATE[HY000] [2002] Connection timed out
How can i fix this
-
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
-
1If 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
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
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.
answered Sep 27 '16 at 5:38
