User Tools

Site Tools


docu:csheet:sysadm:db:my:57_date_problem

How to fix 5.7 datetime field problems on dump/restore


If you ever step yourself in front of a MySQL 5.7, you better hide your head in the sand, if there is no choice and you have to fix it anyways, issue this command on a mysql cli before restoring/executing SQL commands.

SET global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
docu/csheet/sysadm/db/my/57_date_problem.txt · Last modified: 2020/02/27 15:26 by admin