Default Table Type

[JamesBrown]

In Ver 5.0.30 the default table type is INNODB. Is there a way to change this to MYISAM?

[.jp]

dbForge Studio uses the state of the server "default_storage_engine" variable. To check it please run the following query:

Code: Select all

SHOW VARIABLES LIKE 'default_storage_engine';

Change the value of this variable and you will solve this problem.

[JamesBrown]

Yes I see the Server Variable but I cannot seem to change it. The docs. say:

"To change variable value, click in the Value column for the required variable row and edit variable. Press ENTER to apply changes or ESC to discard them"

But this does not seem to work.

I'm a nube at this so I will need some additional help.

Thanks......... Jim

[.jp]

It is not a session variable, so you cannot change it "on the fly".
You first should locate the MySQL config file named my.cnf (or my.ini). Then in that file find the [mysqld] and add the following line below it as shown below.

Code: Select all

[mysqld]
default-storage-engine = myisam

You also should make sure you restart MySQL server.

[JamesBrown]

Sweet - Thanks much...

[JamesBrown]

I changed the MySQL conf file as you suggested and restarted the server (actually rebooted to be sure) and the:

Show Variables Like 'default_storage_engine';

does show the value is MyISAM but.
Studio for MySQL still defaults to INNODB.

Is this a bug?

[Viktor]

Is this a bug?

Yes, this is a bug. It will be fixed in the next build.

[.jp]

Is this a bug?

Yes, this is a bug. It will be fixed in the next build.

The build with fixes is on the site. Please download it.