MySQL Converting ISAM to MyISAM

Some old database tables needed to be converted. This can be done at the mysql command prompt with:

ALTER TABLE tbl_name TYPE = MYISAM;

Or using the script ‘mysql_convert_table_format’ which is located in the MySQL bin folder. Usage:

./mysql_convert_table_format test –user=root –password=secret

be careful as InnoDB tables will also be converted to MyISAM.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>