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 <[EMAIL PROTECTED]> 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 > [email protected] > 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 [EMAIL PROTECTED] |Full Demos at http://liblime.com/koha |1(888)KohaILS _______________________________________________ Koha-devel mailing list [email protected] http://lists.koha.org/mailman/listinfo/koha-devel
