Sorry, ----- Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 08, 2003 12:39 AM Subject: Re: InnoDb and fragmentation
> Mike, ... > > So how do I "defrag" the InnoDb file space so I can get it back > > up to speed? > > The simplest method is > > ALTER TABLE ... TYPE=MYISAM; > ALTER TABLE ... TYPE=INNODB; I forgot to mention that the above method removes your FOREIGN KEY constraints in the table! If you have them, best to use mysqldump, and remember to put that SET FOREIGN_KEY_CHECKS=0 at the start of the dump files if you do not import the tables in the right order. ... > > Mike > > Best regards, > > Heikki Tuuri Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]