Importing: Autocommit =false or use of Mysql, LOAD DATA IN FILE

[david71076]

Hi all.

 

My excuses if this topic is already created, maybe not the next procedure:

 

I have to upload a catalog products of 10000 products aproximately, then i need to know the fastest way do it daily, because the catalog change with this frecuence, then my questions are:

 

1) There is any way to set autocommit = false, just for uploading products? How can i do it.

2) I was trying to do a CSV export / import using LOAD DATA IN FILE procedure from mysql but i have not clear the tables to export import without affect prestashop right functions.

 

Any help about this topic, could be very apreciated.

Thanks very much.

David

[vekia]

duplicated: http://www.prestashop.com/forums/topic/299084-importing-autocommitfalse-or-use-of-mysql-load-data-in-file/

please continue discussion in topic linked above.

topic closed.