Prev: Slackware on Gateway Solo 1100 laptop (vintage 2000)
Next: dropline-installer
From: Helmut Hullen on 17 Jun 2008 01:42
Hallo, Bob,

Du meintest am 16.06.08:

> I am having a difficult time configuring the stock MYSQL package for
> 12.1

> I would like to have the default engine = innodb

> I have tried adding
> default-storage-engine = INNODB in my.cnf - go good

Why?
It's the default engine, no need to declare it.

> I have also tried --default-storage-engine=INNODB when starting
> mysql, and still no luck.

What error is reported?

Viele Gruesse
Helmut

"Ubuntu" - an African word, meaning "Slackware is too hard for me".

From: No_One on 17 Jun 2008 02:20
On 2008-06-16, Bob De Mars <bob(a)grunners.com_nospam> wrote:
> I am having a difficult time configuring the stock MYSQL package for 12.1
>
> I would like to have the default engine = innodb
>
> I have tried adding
> default-storage-engine = INNODB in my.cnf - go good
>
> I have also tried --default-storage-engine=INNODB when starting mysql,
> and still no luck.
>
> I have also uncommented the innodb option in my.cnf.
>
> Any insight on what I might be doing wrong would be great.
>
> Thanks,
>
> Bob De Mars

Try looking in the file /var/lib/mysql/localhost.err ... might give some
info.

I'm using an older version of mysql and slack...maybe it's called something
else.

Should be in the same dir as the mysql databases

ken
From: Jeffrey Froman on 17 Jun 2008 11:03
Bob De Mars wrote:

> default-storage-engine = INNODB in my.cnf - go good
<snip>
> I have also uncommented the innodb option in my.cnf.

These two options together should be enough. I have always used "innodb"
(lower-case), but I'm not sure that makes any difference.


Jeffrey
From: Jeffrey Froman on 17 Jun 2008 11:03
Helmut Hullen wrote:

>> I have tried adding
>> default-storage-engine = INNODB in my.cnf - go good
>
> Why?
> It's the default engine, no need to declare it.

MySQL's default engine is MyISAM. To obtain a default of INNODB, it must be
explicitly configured.


Jeffrey
From: Helmut Hullen on 17 Jun 2008 14:50
Hallo, Jeffrey,

Du meintest am 17.06.08:

>>> I have tried adding
>>> default-storage-engine = INNODB in my.cnf - go good

>> Why?
>> It's the default engine, no need to declare it.

> MySQL's default engine is MyISAM. To obtain a default of INNODB, it
> must be explicitly configured.

Sure?
I use MySQL for some years under slackware, without any special
configuration.

/var/lib/mysql/<host>.err

tells for the last reboot (some hours ago)

080617 07:33:06 mysqld started
080617 7:33:08 InnoDB: Started; log sequence ...

Nothing with MyISAM.

Viele Gruesse
Helmut

"Ubuntu" - an African word, meaning "Slackware is too hard for me".

 |  Next  |  Last
Pages: 1 2
Prev: Slackware on Gateway Solo 1100 laptop (vintage 2000)
Next: dropline-installer