Domas Mituzas a écrit :
Hello,
Besides performance questions may I emphasize on the non robustness of the innodb mode. Reccntlty I have lost the whole content of a Wiki (naively, how could I know?) saved while mysql was running. The other wiki using MyISAM has been recovered. This very fragile innodb behaviour is inacceptable.
Did you remove 'ibdata' file manually? That is the major common reason of 'data lost' with InnoDB.
--Domas Mituzas -- http://dammit.lt/ -- [[user:midom]]
I copied the whole mysql directory, manually. A practice i used for years, because mysqldump is very lunatic. I was working fine. Then I installed a new Wiki 1.9.3. After a system crash I recovered the old Wiki but not the new one. That is very bad, how could I be aware of this innodb things ?
Best,
Francois Colonna