this looks great. will this work with version 4.04 on solaris? as a side comment, anyone know when 4.1 will get out of the alpha stage? very much looking forward to upgrading, but only when its relatively stable.
jeff Per Andreas Buer wrote: > > 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] -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6 http://www.predict.com Santa Fe, NM 87505 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
