[Solved] Does 1.4.0 use InnoDB or MyISAM by default?

[keweli]

I need to know which one was used because my new webhost upgrade seems to NOT support InnoDB.. Gosh, I paid for a much more expensive server and things are going crap.

I am getting tons of errors moving from 1.4.0 to 1.4.3. I start to suspect this is because my data got converted from InnoDB to MyISAM.

[Thomas Didierjean]

Hi,

When you first install PrestaShop, on the database configuration page, you can choose between InnoDB and MyISAM. The default selection is InnoDB.
When upgrading, PrestaShop does not change the MySQL engine, so whichever engin was selected during install is used.

Regards,

[keweli]

Thanks, I just needed to know the default format

When I upgraded my webhost, the new server did not support InnoDB and converted everything to MyISAM instead. This gave me major SQL problems on the site as they had also corrupted some tables.

After getting the server to enable InnoDB, I repaired the tables and converted them back to InnoDB format. Most problems seemed to be solved now.

The irony is that I upgraded to a more expensive web server within the same company.

[shokinro]

if you use back up and restore, which is based on SQL statement, I think the problem should not happen.
because the SQL statement is independent of database engine.

[keweli]

Yeah you are right both InnoDB and MyISAM can be used interchangeably but I prefer InnoDB.

The real problem is that they had corrupted a few of the tables while converting.