Heiki Thx... it's work :D Sorry, one liner Heikki Tuuri <[EMAIL PROTECTED]> wrote: Ady,
----- Alkuperäinen viesti ----- Lähettäjä: "Ady Wicaksono" Vastaanottaja: "Ady Wicaksono" ; "Heikki Tuuri" Kopio: Lähetetty: Friday, September 03, 2004 10:41 AM Aihe: Re: Problem on InnoDB - Tablespace enough but engine said table full > I try to detect using MC (Midnight Commander) and found that after ;/data4/ibdata25:1802M > > it won't write anymore... > > I remove these data file and add /ibdata1/ibdata10:1500M and /data1/ibdata11:1500M > > I believe, All data below is empty but corrupt :( > > ---- data file defintion -- > #/data4/ibdata25.data3:576M;/data1/ibdata10:1500M; > #/data1/ibdata11:1500M;/data1/ibdata12:1500M;/data1/ibdata13:1500M;/data2/ib data14:1500M;/data2/ibdata15:1500M;/data2/ibdata16 > :1500M;/data2/ibdata17:1500M;/data2/ibdata18:1500M;/data2/ibdata19:1500M;/da ta3/ibdata20:1500M;/data3/ibdata21:1500M;/data3/ib > data22:1500M;/data3/ibdata23:1500M;/data3/ibdata24:1500M; > --- data file defintion -- > > I change my innodb_data_file_path to: > > 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;/data1/ibdata10:1500M > ;/data1/ibdata11:1500M > > It's working since i know i have 877184 pages now, later i simply add something like /data1/ibdata12:1500M > > but, i still have error when starting...., here is > > InnoDB: Error: tablespace size stored in header is 877184 pages, but > InnoDB: the sum of data file sizes is 953856 pages > > How to fix it ? since i found every data in innodb_data_file_path is not empty (953856 - 877184) / 64 = 1198 MB 1) Stop the mysqld server. 2) Add a new 1198M ibdata file at the end of innodb_data_file_path. 3) When you start mysqld, InnoDB will write that new ibdata file full of zeros, and increment the tablespace size stored in the tablespace header by 1198M. 4) Then stop the mysqld server, remove the extra 1198M ibdata file from innodb_data_file_path and delete that extra ibdata file. 5) Start mysqld again. 6) Voila! Now the tablespace size stored in the tablespace header agrees with the combined size of the files in innodb_data_file_path! Be very careful! From now on always follow the instructions at http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html when you want to add a new ibdata file. > Thx 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 --------------------------------- Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now.