Topic: Solved - Moodle 2x and InnoDB

[bloodshoteye]

Hi All,

Using SME 8.0 beta 6, fully patched:
I put Moodle into an ibay and configured a subdomain (URL is http://moodle.domain.tld)
All seems fine, can access via LAN and WAN.
My question is a notification Moodle is making about InnoDB compared to MyISAM:

Database tables are using MyISAM database engine, it is recommended to use ACID compliant engine with full transaction support such as InnoDB.

If I enable the InnoDB engine (obviously also re-installing Moodle) as per [[http://wiki.contribs.org/MySQL#Enable_InnoDB_engine]], will other existing MyISAM databases on the same box be affected?

Cheers,

[bloodshoteye]

Replied to self:

To convert a non-InnoDB table to use InnoDB use ALTER TABLE:
ALTER TABLE t1 ENGINE=InnoDB;
Important
Do not convert MySQL system tables in the mysql database (such as user or host) to the InnoDB type. This is an unsupported operation. The system tables must always be of the MyISAM type.

This is from the following authoritative website: http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html
Thus individual DBs can be converted leaving other existing tables as they are. If you want to.

Cheers,

[kwak]

Hi,

Have you manage to install INTL  (php-intl)?

Kwak

[bloodshoteye]

Hi,
Have you manage to install INTL  (php-intl)?
Kwak

I don'y remember installing that, so I did

# yum list installed

- not installed.

Cheers.

[newburns]

How did you place moodle into an IBay. Did you install into an IBay? Please explain.

[bloodshoteye]

How did you place moodle into an IBay. Did you install into an IBay? Please explain.

Far as I recall I simply expanded the tar.gz file in the IBay and followed Moodle's instructions. Also you must set:

Code: [Select]

db accounts setprop <IBay_name> PHPBaseDir /home/e-smith/files/ibays/<IBay_name>/html/:/tmp/
signal-event ibay-modify <IBay_name>
For secure Moodle data set:

Code: [Select]

db accounts setprop <IBay_name> PHPBaseDir /home/e-smith/files/ibays/<IBay_name>/html/:/opt/moodledata/
signal-event ibay-modify <IBay_name>
You will need to make sure the Moodle config file is also set for secure data.

I offer no assurances I am correct as I'm relying on my forgettery.
Cheers