[Koha-devel] ibdata1

[David Schuster]

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.