At 18:58 +0000 12/18/02, John P wrote:
I have about 300 database tables that are mostly ISAM and some MyISAM
format. I would like to move them all into MyISAM - what's the
easiest/quickest way? I am running 3.23.54.
I was thinking of doing mysqldump, then using a search/replace in the file
CREATE TABLE .. TYPE=, then recreating the database files using mysql, but
it seems a bit heavyhanded to me ;)
Thanks,
John
Any single table can be converted using ALTER TABLE:
ALTER TABLE tbl_name TYPE = MyISAM;
For all tables in a given database, you can convert them like this, at
least under Unix:
% mysql -N -e 'SHOW TABLES' db_name \
| sed -e 's/.*/ALTER TABLE & TYPE = MyISAM;/' \
| mysql db_name
---------------------------------------------------------------------
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
