Want to subscribe to topics you're interested in?
Become a Member

MariaDB check mysql strict mode

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by arlon, Nov 15, 2016.

  1. arlon

    arlon Member

    73
    5
    8
    Feb 20, 2016
    Ratings:
    +10
    Local Time:
    8:27 PM
    1.10.1
    10.0
    i'm using mariadb 10.0.28 and i have a problem when backing up my database using CMS, i have contacted my developer that i must disable mysql strict mode, how to check my database strict mode? and how to disable it?
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,174
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,138
    Local Time:
    11:27 PM
    Nginx 1.13.x
    MariaDB 5.5
    What errors you getting during backup ? What CMS is it ?

    You should always for reliability use mysqldump to backup mysql data and not rely on php interfaced mysql backups as they can timeout or result in incomplete backups.

    MariaDB does NOT set STRICT_TRANS_TABLES or STRICT_ALL_TABLES sql modes by default so shouldn't cause problems. What's output of this command
    Code (Text):
    mysqladmin var | grep sql_mode | tr -s ' '
    

    you should get something like this without STRICT_TRANS_TABLES, STRICT or STRICT_ALL_TABLES sql modes listed
    Code (Text):
    mysqladmin var | grep sql_mode | tr -s ' '
    | sql_mode | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
    

     
    Last edited: Nov 16, 2016