My application is supposed to parse hundreds of xml files and enter those records into a MySql database.
I started with the default my.cnf file, that did not have a innodb_data_file_path entry, and got a Error 1114 - Table Full, after it was done entering x number of records.
I tried adding each of the following lines in my.cnf, dropping the whole database and starting afresh to overcome this problem, but none of these helped.
- innodb_data_file_path = ibdata1:10M:autoextend
- innodb_data_file_path = ibdata1:30M:autoextend → This option created a 30MB ibdata1 file, but the table was told to be full at the very same point of execution.
- innodb_data_file_path = ibdata1:10M;ibdata2:10M;ibdata3:10M;ibdata4:10M:autoextend → This option created all the 4 data files, still failed at the same point.
Can anybody tell me how I can move forward, I have been stuck right here for quite sometime now…
Thanks!