Hi, I would like to migrate my DB from Sybase ASE to MySQL INNODB table. Data has been extracted and stored as a file. I want to use the command Load Data Infile to insert the data to MySQL. However, some table contains millions of rows. Can i control the batch size of the loading (e.g. commit the transaction after 50000 rows inserted)? If no, should i define a very large transaction log to handle the huge transaction? (currently, it is 5M) Any suggestion is welcomed. TIA Michael
[EMAIL PROTECTED] 全港最大手機下載中心 http://mobile.yahoo.com.hk/