[debian-mysql] Fwd: Re: Bug#674122: otrs2: fails to upgrade from squeeze: Can't create table 'otrs2.#sql-1712_71
Olaf van der Spek
ml at vdspek.org
Fri May 25 22:27:38 UTC 2012
On Fri, May 25, 2012 at 11:59 PM, Nicholas Bamber
<nicholas at periapt.co.uk> wrote:
> Some ideas. Not sure how the application works so not sure which is
> most liekly to be deoable.
> * There is a --default-storage-engine=type start up option. If you let the
> standard mysql scripts manage the mysqld process that one might not work.
> * It should be possible to convert that option into an option entry in the
> my.cnf file. You should also be able to own your own my.cnf fragment in say
> /etc/mysql/conf.d/otrs2 .
Both are unacceptable, aren't they?
Packages should not set MySQL-side options like the defaulst storage engine.
> * If you only need to enforce the default engine in upgrade scripts (or the
> creation of tables is confined in some other way) then this SQL would do it:
> set default_storage_engine = 'MyISAM';
This looks to be the only simple option.
> However that will only persist as long as that connection.
> * Again you can use this SQL:
> set global default_storage_engine = 'MyISAM';
Again, not acceptable, IMO/
More information about the pkg-mysql-maint