Installing MySQL 5.6 on CentOS 6
MySQL on CentOS6 is currently limited to version 5.1, which sucks. A lot of modern web applications can benefit of running the most recent version… Read More »Installing MySQL 5.6 on CentOS 6
MySQL
Upgrading / Migrating a MySQL 5.0 Database to MySQL 5.5 [InnoDB]
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]
Installing MySQL 5.5 on CentOS 6.x
This post covers the installation of MySQL 5.5 on CentOS 6 (64bit) By default, CentOS 6 ships with MySQL 5.1, but to take all the… Read More »Installing MySQL 5.5 on CentOS 6.x
Reset MySQL root password on CentOS 5.x
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
InnoDB Restore Backup Procedure
My previous post elaborated on some scripts on backing up a MySQL Database with the InnoDB storage engine. This post documents the restore procedure using… Read More »InnoDB Restore Backup Procedure
Monitoring and reporting on a remote MySQL database.
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.
InnoDB Backup Scripts
Following up on my earlier post about converting the storage engine on a MySQL Database from MyISAM to InnoDB, I’d like to share the following… Read More »InnoDB Backup Scripts
Identifying and Repairing MySQL (MYISAM) Table fragmentation
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
MYSQL ERROR 2003 (HY000): Can’t connect to MySQL server on ‘xx.xx.xx.xx’ (111)
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)
Moodle Issues: Backup and restore / course import fails
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