First, databases do not have a table type, they are mainly just a
logical grouping of tables. Mixing table types in a database is quite
alright and is what you are supposed to do. I generally use MYISAM,
but if I have a table with lots of activity (inserts, deletes,
selects) or needs
. Sender does
not necessarily endorse content contained within this transmission.
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: another INNODB vs MYISAM question
Date: Sat, 16 Aug 2008 08:52:51 -0400
CC: mysql@lists.mysql.com
First, databases do not have a table type
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, [EMAIL
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