Tag strict mode

check mysql / mariadb table for primary key

MySQL

Row size too large (> 8126). Changing some columns to TEXT or BLOB… | Mysql / MariaDB

We recently migrated a client website to a new server and encountered the following error when trying to import their database: ERROR 1118 (42000) at line 2663: Row size too large (> 8126). Changing some columns to TEXT or BLOB…

theshell
January 7, 2021

MySQL

MySQL / MariaDB: Disable strict mode | Upgrading to MariaDB 10.2

We recently needed to upgrade a server from MySQL 5.7 to MariaDB 10.3 and one of the key steps in doing so is to disable strict mode after the upgrade. By default, MariaDB enables strict mode from version 10.2 and…

theshell
October 14, 2020