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]
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
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
A couple months ago I posted on a modified php script to convert tables MySQL tables from MyISAM to InnoDB. It worked all well and… Read More »Batch convert MyISAM tables to InnoDB from Terminal
I wrote (or rather modified an existing script) that batch converts the moodle database from MyISAM to InnoDB. This saves a lot of time, rather… Read More »Moodle: PHP script to convert Mysql database from MYISAM to InnoDB
My last post dealt with the installation of the Percona Xtrabackup tool for use on a Mysql innodb database.After some tweaking and help from the… Read More »Testing Percona Xtrabackup (innobackupex)
This covers the basic installation of the xtrabackup package on CentOS. This is necessary in order to take hot backups of a database using the… Read More »Installing Percona xtrabackup on CentOS 5.x