Forums / Install & configuration / ezconvertmysqltabletype.php

ezconvertmysqltabletype.php

Author Message

Björn Dieding@xrow.de

Tuesday 20 September 2005 7:23:41 am

I have problem...

I am trying to convert from myisam to innodb

I tried

php bin\php\ezconvertmysqltabletype.php -seng_admin --newtype=innodb -d

After I viewed the DB in mysqladmin it is still myisam.

What could be the reason? All queries are successfull...

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Hans Melis

Tuesday 20 September 2005 8:28:29 am

Does your MySQL have support for InnoDB?

Or do you have the <b>skip-innodb</b> startup option enabled?

Hans
http://blog.hansmelis.be

Björn Dieding@xrow.de

Tuesday 20 September 2005 9:12:04 am

HI hans

this was the case... yes inndb was disabled... ty

I rerun the mysql configurator and set it up with innodb... I also had to upgrade from 4.1-7 to 4.1-14. 4.1-7 was crashing for some reason

[mysqld]
default-storage-engine=INNODB

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/