MySQL

Configuration of MySQL

Increase the maximum allowed asset size

Assets, i.e. binary documents like pdf and images, are stored as a single packet. This means that assets larger than the max allowed packet are not stored in the database. Increase the max_allowed_packet variable of your MySQL server to allow for larger assets. Be aware that this will reduce performance.

Case sensitivity of database and table names

When exchanging data dumps between different platforms like Windows and Linux there is the potential issue that table names are not recognized due to case-sensitivity differences. You can fix this problem by seting the lower_case_table_names system variable to 1. See MySQL reference manual

Configuring Hippo CMS for MySQL

See these configuration instructions on the wiki.

Hippo Europe: +31 (0)20 5224466
Hippo North America: +1 (707) 773-4646