Tablespace not autoexpanding

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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:au toextend --> 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...


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