Michael, All your e-mails come as an attachment in my mailbox instead of plain e-mail.
>> Why not simply recreate it with the InnoDB table type? >> >> If there's data in it, rename the old table, recreate the >> table and pump the data. >> >> All done! > >Certainly that *COULD* be done, but it shouldn't be necessary (according to >the documentation). In addition, one of the tables needing this doesn't just >have data in it ... it has A LOT of data in it. It would not be a small, >short running job. Well, I'm not a MySQL pro at all, but if this InnoDB is running in its own table space, the data will have to be transferred into there anyway. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]