Re: Converting tables to MyISAM

2001-03-09 Thread MikeBlezien
On Fri, 9 Mar 2001 18:41:46 -0500, "Tac/Smokescreen Action Network" <[EMAIL PROTECTED]> wrote: >> >>I've searched the MySQL manual and can't figure out how to convert one (or >>all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to >>3.23). >> >>I think there's a way to do it

Re: Converting tables to MyISAM

2001-03-09 Thread denis
Try: alter table [tablename] type = myisam; There is a script that purports to do this for you, but the copy that I had wouldn't run properly, so I just made a file of the SQL needed, and ran it through mysql... Tac/Smokescreen Action Network wrote: > I've searched the MySQL manual and can't f

Converting tables to MyISAM

2001-03-09 Thread Tac/Smokescreen Action Network
I've searched the MySQL manual and can't figure out how to convert one (or all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to 3.23). I think there's a way to do it from the ALTER TABLE command, but I can't seem to find any examples. Thx, Tac ---