Page 1 of 1
Default Table Type
Posted: Thu 12 May 2011 21:37
by JamesBrown
In Ver 5.0.30 the default table type is INNODB. Is there a way to change this to MYISAM?
Posted: Fri 13 May 2011 06:26
by .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.
Getting Close
Posted: Fri 13 May 2011 14:26
by 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
Posted: Fri 13 May 2011 15:17
by .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.
Works
Posted: Fri 13 May 2011 15:23
by JamesBrown
Sweet - Thanks much...
Well I thought It Was Fixed
Posted: Sun 15 May 2011 00:37
by 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?
Posted: Mon 16 May 2011 10:25
by Viktor
Is this a bug?
Yes, this is a bug. It will be fixed in the next build.
Posted: Thu 19 May 2011 06:20
by .jp
Viktor wrote: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.