Tablespace not autoexpanding

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.

  1. innodb_data_file_path = ibdata1:10M:autoextend
  2. 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.
  3. 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!

Can you please let us know what is in MySQL error log?