Most steps must be done as root.
Apache2 webserver >= 2.2.x
the following Apache modules should be enabled
rewrite / filter / deflate / headers / expires
:OTHER_PHP_PATHS
innodb_file_per_table
See the current config:
SHOW VARIABLES WHERE Variable_name = 'sql_mode';
Set in config if needed:
sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Set in config if needed:
log_bin_trust_function_creators = 1
post_max_size=600M
upload_max_filesize=600M
max_execution_time=3600 #for production instances and large files in imports to be on the save side
memory_limit=1024M #or higher, if possible for production instances and large files in imports to be on the save side