Setting Default Engine Type For New Tables

[krisleech]

how do i set a default engine type for new table?

currently it defaults to MRG_MyISAM.. which does not allow inserts.

thanks kris.

[peterlaursen]

1) From SQLyog GUI:

right click the table in Object browser … change table type to .. and choose what you'd like!

2) SQL

Execute this:

ALTER TABLE `dbname`.`tablename` type = ISAM;

(or whatever type).

Comment: The merge table type is really not interesting any more with modern OS's and filesystems It was created in order to be able to have very big databases exceeding the file size possible. But with Windows/NTFS or LINUX/EXT3FS there is no need for merge tables.

You can read about the merge table type in the MySQL documentation.

[Ritesh]

To set the default engine use this in the my.cnf file: default-table-type=MyISAM

[peterlaursen]

I am sorry I missed the point 😡

You asked for the default table type for a NEW table. Ritesh gave the answer. However, you can altter such settings from “MySQL Administrator” too, if you prefer.

It is available from http://dev.mysql.com

[krisleech]

thanks both!

But… I dont find the my.cnf file in the install folder, i have SQLyog.ini.

Do i need to make my.cnf or should it already be there.

I have show hidden files enabled.

Thanks again, K.

[Ritesh]

http://dev.mysql.com/doc/mysql/en/option-files.html

[Ritesh]

Its a MySQL configuration file and has nothing to do with SQLyog.

[krisleech]

Thanks a lot!

[Author]

Posts