List:General Discussion« Previous MessageNext Message »
From:Doug Bridgens Date:August 15 2008 8:49am
Subject:Re: another INNODB vs MYISAM question
View as plain text  
if you switch the default engine type any new tables would be created  
with that new engine type.  it does not convert existing tables to  
your new format.

if you have existing innodb tables you need to have the innodb  
settings active, in my.cnf



On 15 Aug 2008, at 06:01, mikesz@stripped wrote:

> Hello mysql,
>
> As I have previously mentioned, I installed WAMPSERVER 2.0 on my
> Windows XP pro box recently. It installed INNODB as the Default
> Engine.
>
> All of my legacy Databases are MYISAM and after the installation, I
> copied them all into the DATA folder and everything worked, even
> adding new tables etc. but the new stuff was INNODB. So I ended up
> with some MYISAM databases that contained INNODB tables in them.
>
> After a few weeks I got to thinking that mixing INNODB and MYISAM
> might not be a good thing and switched the Default Engine to MYISAM in
> my.ini file. I didn't just switch the default, I commented out all the
> INNODB calls in the my.ini file as well.
>
> As I half expected, all the databases that I had added INNODB tables
> failed when I tried to fire up the applications that used them.
>
> Although I am not new to mysql, I have had a bit of MYISAM "tunnel
> vision" with it so my question is, if I had just switched the default
> engine and NOT disabled the INNODB calls in my.ini, would that have
> prevented the "problem"? I restored all the MYISAM files and got
> everything back working again.
>
> I don't want to go through the "lengthy" reproduction exercise of
> reinstalling everything to test the theory so if someone has had some
> experience with this, I would appreciate hearing from them.
>
> -- 
> Best regards,
> mikesz                          mailto:mikesz@stripped
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>

Thread
another INNODB vs MYISAM questionmikesz15 Aug
  • Re: another INNODB vs MYISAM questionDoug Bridgens15 Aug
  • Re: another INNODB vs MYISAM questionBrent Baisley16 Aug
    • RE: another INNODB vs MYISAM questionMartin Gainty16 Aug