Hello Heikki, "Heikki Tuuri" <[EMAIL PROTECTED]> writes:
> I think a 'null' alter table operation: > > ALTER TABLE innodbtable TYPE=INNODB; > > does the defragmentation with just one build of the table. And I think it > also preserves FOREIGN KEY constraints. > > Please test it! It did the job just fine. Thanks. -- Per Andreas Buer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]