Tag: MySQL

MySQL server has gone away. But where did it go? PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: This can be a tear your hair out

You’ve got a database you want to move or copy from, say, staging to production. You’ve had HeidiSQL open for a while and now it’s time to go

A couple handy scripts to help tune MySQL https://answers.launchpad.net/mysql-tuning-primer/+question/166577https://launchpad.net/mysqltuner https://answers.launchpad.net/mysql-tuning-primer/+question/166577 Update: not worth using these as the actually end being self-defeating. They use the very same resources that

Quick reference: For Schemas: SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = “schemaname”; For Tables: SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema