MySQL Got a packet bigger than ‘max_allowed_packet’ bytes
We were doing a big database import in MySQL and we got this error message during the process. Got a packet bigger than 'max_allowed_packet' bytes. Here are the changes we…
mysqldump: Couldn’t execute ‘SELECT @@GTID_MODE’: Unknown system variable ‘GTID_MODE’ (1193)
If you are using the MySQL 5.6 version of mysqldump on an older MySQL database, you might get the error message. This error is in part due to the introduction…
MySQL 5.6 – Specified key was too long; max key length is 767 bytes
We recently upgraded to MySQL 5.6, and one of our web applications started failing our automated tests. We have a test that drops all our tables and recreates them again,…