Store Import Issue

I have a 2.2.5 store with a very large database. When I try to import into 4.1.4, it seems to time out during the initial import. CS-Cart support suggested I change the mysql.connect_timeout setting, but that’s not something my host will do. I could run the import on an internal server, but I’m concerned about actualizing the data before the new store launches. I can’t afford to shut down my store for a whole day while the import runs. Any suggestions?

For what it's worth, the import seems to get hung on the cscart_new_orders table. That table has 1.8 million records going back to January 2009.

I have a 2nd store that's failing to import. The store import logs show it fails at the same place every time.


1400267838 - Updating data
1400267838 - Upgrading to 301
1400267838 - 1
1400267838 - Importing data
1400267838 - 1
1400267838 - Importing data
1400267838 - 12
1400267838 -
Importing data
1400267838 -
Creating table: IF
1400267838 -
Importing data
1400267838 -
Importing data
1400267839 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data
1400267841 -
Importing data




“Upgrading to 301” is the last thing that pops up on screen before the store import progress disappears.

Do you have third party addons installed? You may have to disable those. In the end I had to have CS-Cart support do the import for me when moving to 3.0.6 from 2.x.

I don't have any third party addons in this store. The import script seems to stop after 359 or 360 seconds every time. I'm not sure if that's a PHP setting or something.

Possibly server time out setting to 360 sec for mod_fcgi



John

I'm still dealing with these timeout issues. Now, it's happening in 2 separate stores on 2 separate servers. I asked CS-Cart support for assistance, and they were able to import in a local environment and upload the database. But, I still need to actualize the data to pull new customers and orders since then. When I try to actualize, it seems to stop at random. Sometimes it's a few minutes - sometimes it's close to an hour. This is on a separate server from the first site I was having trouble with. I've deleted several thousand orders from this new store, but I still have 60,000+ to import.



Does anyone have any further advice or troubleshooting suggestions? Both the store owner and me are getting very frustrated.