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,
I should
 alter table type two times: to MyISAM and back to InnoDB.
Uh, well, what I wrote below shows how to do that. :-)

Or dump &
load
 data.
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:[EMAIL PROTECTED]]
 Sent: Friday, December 27, 2002 11:50 AM
 To: ¡§ «¦„Á; [EMAIL PROTECTED]
 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.

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to