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: http://cloudsurvivalguide.com/owncloud-ubuntu-ispconfig/

    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 3.0.5.4p8 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