Arch Linux

_Mike_

Member

Registered: 2005-03-09

Posts: 30

MySQL: Can't convert MyISAM to InnoDB (database corruption with MyISAM

Hi, I want to convert my tables to InnoDB. Where I live we have frequent power outages and I don't have money for UPS, my database gets corrupted everytime. I read that InnoDB was better at surviving power outages so I want to try out. (If you have any other tip for surviving power outages you are welcomed).

I tried with:

ALTER TABLE tablename ENGINE=INNODB; 

but they where not converted, I checked with

SHOW TABLE STATUS;

and they still were using MyISAM.

Doing:

show engines;

There is no mention of InnoDB, so I guess the mysql package from the repos doesn't support it.

Is there a way to enable it without recompiling? I'm currently using another distro and that PC with Arch and the database doesn't even have internet access. Is there a mysql package with InnoDB enabled so I could just take the package there on a pen drive and do "pacman -U mysql" ?

Any ideas are welcomed. Thx.