Ady, InnoDB thinks that the tablespace size is 10 706 MB.
You have specified 36 782 MB of data files in the my.cnf line :(. Now you should figure out what are the data files that InnoDB is using, and remove the end of the innodb_data_file_path line, as well as the unused ibdata files. Remember that InnoDB uses data files starting from the first, in the order that you list them in innodb_data_file_path. Be very careful! Do not remove your valuable data! After that, you can grow the tablespace as instructed at http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL support from http://www.mysql.com/support/index.html ............. I have MySQL for heavy duty job ..... here is my InnoDB table space definition innodb_data_file_path = \ /data0/ibdata1:10M;/data0/ibdata2:10M;/data0/ibdata3:1082M;/data0/ibdata4:15 00M;/data0 \ /ibdata5:1500M;/ data0/ibdata6:1500M;/data0/ibdata7:1500M;/data1/ibdata8:1500M;/data1/ \ ibdata9:1500M;/data4/ibdata25:1802M;/data3/ibdata25:1802M \ ;/data4/ibdata25.data3:576M;/data1/ibdata10:1500M;/data1/ibdata11:1500M;/dat a1/ibdata1 \ 2:1500M;/data1/ibdata13:1500M;/data2/ibd \ ata14:1500M;/data2/ibdata15:1500M;/data2/ibdata16:1500M;/data2/ibdata17:1500 M;/data2/i \ bdata18:1500M;/data2/ibdata19:1500M;/dat \ a3/ibdata20:1500M;/data3/ibdata21:1500M;/data3/ibdata22:1500M;/data3/ibdata2 3:1500M;/d \ ata3/ibdata24:1500M; What i don't understand is : after ibdata1 -> ibdata9 full is go to /data4/ibdata25 ... (1802Mbyte) But it's not continues to write to /data4/ibdata25.data3... /data1/ibdata10 and so on but said table .... is full when i try to write data to table The question is why ? Secondly What is the meaning of InnoDB: Error: tablespace size stored in header is 685184 pages, but InnoDB: the sum of data file sizes is 2354048 pages Thx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
