Thank you very much. I did not know this command. Well at least I never
looked up what it does.
I'll give it a try and see how it works out.
Why not just use an OPTIMIZE TABLE xxxx? This will map to an ALTER table
command for an InnoDB table which will free the now unused space. From
the manual at http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE, which
rebuilds the table to update index statistics and free unused space in
the clustered index.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]