------------------------ Per Andreas Buer <[EMAIL PROTECTED]> wrote: ------------------------ Hello Heikki, > >"Heikki Tuuri" 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.
and it seems to be what I asked for as well, thanks! Franky -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]