As I watch this file grow I am wondering how to clear it. I saw this on a mysql list, but wanted to get developer insight... March 2007 Location: Sweden Senior Member A very cumbersum way: 1.mysqldump all databases 2.Remove the ibdata1 file. 3.Start the mysqld process. It will now recreate the ibdata1 table space since it recognizes that it is missing. 4.Import the sql dump from step 1 and you are back again. -- View this message in context: http://www.nabble.com/ibdata1-tp19400910p19400910.html Sent from the Koha - Dev mailing list archive at Nabble.com.
Hey David, ibdata1 is the default name of the data file for tables stored using the InnoDB engine, so it will naturally grow, and depending on the data set, can get quite large. Hope that's helpful. Cheers, Josh On Tue, Sep 9, 2008 at 4:45 PM, David Schuster <dschust1@tx.rr.com> wrote:
As I watch this file grow I am wondering how to clear it. I saw this on a mysql list, but wanted to get developer insight...
March 2007 Location: Sweden Senior Member A very cumbersum way: 1.mysqldump all databases 2.Remove the ibdata1 file. 3.Start the mysqld process. It will now recreate the ibdata1 table space since it recognizes that it is missing. 4.Import the sql dump from step 1 and you are back again.
-- View this message in context: http://www.nabble.com/ibdata1-tp19400910p19400910.html Sent from the Koha - Dev mailing list archive at Nabble.com.
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
-- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
participants (2)
-
David Schuster -
Joshua Ferraro