according to http://dev.mysql.com/doc/refman/5.5/en/sto...ne-setting.html

 

If you omit the ENGINE option, the default storage engine is used. The default engine is InnoDB as of MySQL 5.5.5 (MyISAM before 5.5.5).

i'm not sure if this was an oversight, or intentional behavior. InnoDB should NOT be disabled, and in fact should have been the default since way-back: Uniform Server v5.7.0

 

regards,

leon

Actually, the reason is for portability and separation of installed apps. If you have two apps that both use InnoDB, the data is mixed in the ibdata1 file. This makes it more difficult to do simple data moves, where the MyISAM data is kept in each db's subdirectory. The application plugins make use of this to simplify installation.

 

The other reason is that's the way it's been for a long time.

 

Regards,

BobS

Actually, the reason is for portability and separation of installed apps. If you have two apps that both use InnoDB, the data is mixed in the ibdata1 file. This makes it more difficult to do simple data moves, where the MyISAM data is kept in each db's subdirectory. The application plugins make use of this to simplify installation.

 

The other reason is that's the way it's been for a long time.

 

Regards,

BobS

 

this seems like the solution needed for portability, no?

 

http://dev.mysql.com/doc/refman/5.0/en/inn..._file_per_table