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?– MartySCommented Sep 18, 2016 at 13:16
-
it's failed means not import single product also– Magento 2Commented Sep 18, 2016 at 15:54
-
restart mysql at server and also check your credential in magmi and try again– Murtuza Zabuawala ♦Commented Sep 19, 2016 at 3:50
-
I done restart my sql still same error– Magento 2Commented Sep 19, 2016 at 17:32
-
1If your magento store is working properly then you have entered the database credentials wrong in the magmi profile– GokuCommented Sep 21, 2016 at 5:18
|
Show 2 more comments
2 Answers
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, 2016 at 5:38
