This post is an ultra, no, make that uber paranoid method of upgrading/migrating a relatively large (20+ GB on file) InnoDB database from MySQL version… Read More »Upgrading / Migrating a MySQL 5.0 Database to MySQL 5.5 [InnoDB]
I had one of those oh-crap moments and forgot the mysql root password in one of my development/test machines.This is a reblog of someone else’s… Read More »Reset MySQL root password on CentOS 5.x
Depending on your environment, you won’t grant every single server on your network the ability to send email. This sort of security precaution had me… Read More »Monitoring and reporting on a remote MySQL database.
I had to perform some server maintenance recently, so I decided to re-run the handy mysql tuner tool, as mentioned in my Database Tuning entry.… Read More »Identifying and Repairing MySQL (MYISAM) Table fragmentation
So I was thrown this error recently, while setting up a testing mysql environment and attempting to access it from a remote host. Usually it’s… Read More »MYSQL ERROR 2003 (HY000): Can’t connect to MySQL server on ‘xx.xx.xx.xx’ (111)
It was one of those strange situations that popped up after a disaster recovery scenario. The database server suffered hardware failure, but that was quickly… Read More »Moodle Issues: Backup and restore / course import fails