Is it safe to change MySQL/MariaDB logging?

Discussion in 'Installation/Configuration' started by brainsys, Jul 17, 2015.

  1. brainsys

    brainsys Member

    Tried installing ownCloud 8.1 last night using the instructions from here:

    It had a MariaDB issue on setup with the message: "Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT". Googling suggests the solution is to change "binlog_format = MIXED" for logging.

    Would this have any side effects with ISPConfig? This is a mirror system on Jessie.

    Luvvin' ISPConfig more every day ...
  2. florian030

    florian030 Well-Known Member HowtoForge Supporter

    You can use binlog_format = MIXED. Only make sure, that your sql_mode is NO_ENGINE_SUBSTITUTION Run "SELECT @@sql_mode;" in mysql or phpmyadmin. You should see an empty result or NO_ENGINE_SUBSTITUTION

Share This Page