At 11:56 +0900 12/27/02, Chung Ha-nyung wrote:
> What I'd like to do is not to alter table type but to optimize table.
> Somewhere I read that to optimize the structure of innodb type table,
> alter table type two times: to MyISAM and back to InnoDB.
Uh, well, what I wrote below shows how to do that. :-)
>Or dump &
Do that with two commands:
mysqldump --opt db_name tbl_name > dump.sql
mysql db_name < dump.sql
> Chung Ha-nyung <alita@[neowiz.com|kldp.org]>
> Sayclub <http://www.sayclub.com>
> NeoWiz <http://www.neowiz.com>
>> -----Original Message-----
>> From: Paul DuBois [mailto:paul@stripped]
>> Sent: Friday, December 27, 2002 11:50 AM
>> To: ¡§ «¦Á; mysql@stripped
>> Subject: Re: Optimize InnoDB table...
>> At 15:13 +0900 12/26/02, Chung Ha-nyung wrote:
>> > I've heard that I should periodically alter innodb table
>> to MyISAM and
>> > back to InnoDB to optimize table structure.
>> > I guess only dropping index and recreating it is enough,
>> but should I
>> > change table type?
>> Dropping an index doesn't change a table's type. You can change the
>> type like this:
>> ALTER TABLE t TYPE = MyISAM;
>> ALTER TABLE t TYPE = InnoDB;
> > >query.