Tagged: innodb backup

It’s official, Percona XtraBackup does not support MariaDB 5.2 & 5.3 MySQL yet

Percona XtraBackup tool for non-blocking MySQL InnoDB and XtraDB backups has been out for a while now. There’s been an outstanding bug #733665 logged since March, 2011 with regards to Percona XtraBackup’s innobackupex-1.5.1 script not detecting MariaDB 5.2 and now 5.3 based MySQL forks. When you run Percona XtraBackup’s innobackupex-1.5.1...

MySQL Back up & Restore: Faster InnoDB database backup / restore using Mydumper and Myloader multi-threaded tools

Previous article compared MyISAM database backup methods for mysqldump and multi-threaded Mydumper/Myloader tools. This time testing a full 100% InnoDB database and comparing InnoDB backup and restore times with mysqldump non-blocking (–single-transaction ) backup and restore with Mydumper and Myloader multi-threaded backup tools. When it comes to backup and restores,...

mysqlmybackup.sh – multi feature MySQL database backup and restore script with Percona XtraBackup & Mydumper tool support

mysqlmybackup.sh started out as a mysqldump based MySQL back up script which I started on June 20th, 2011. I compiled the script based on the modified MySQL mysqldump backup script by Vivek Gite and merged it with Zarafa.com script. Script Evolution: The script has since evolved from the original Vivek...