So I think I am having problems with a component of Joomla because I do not have my db setup to use the InnoDB engine. I think this because I have not changed anything in the running of MySQL and believe MyISAM to be the defualt. Is there a way to check this first of all?
Secondly, if what I believe to be true is, does anyone know any good resources/guides for converting a DB from one engine to another? I have found a few but hasten to point out that I am a massive SQL beginner and this is proving to be somewhat of a baptism of fire. The guides I have looked at so far are all somewhat varied in their approach and a lot of the commands are all pumped together making it somewhat tricky to work out what is going on. The big boon is that this server is virtual and I have already taken a bunch of snapshots so any errors are not major.
I am using a Lamp stack with Ubuntu 9.10 x64, Apache 2.2.12, MySQL 5.1.37 and PHP version 5.2.10-2