This post will guide you to set up and automate the MySQL logical backups using mysqldump on Ubuntu Linux. We will set-up MySQL backup using mysqldump and automate it with Holland backup framework on Ubuntu. Towards the end of the post, you have the steps to be executed in a single block which includes steps for Xtrabackup configuration. Though this post is for Ubuntu Linux with holland + mysqldump while we already have an old post to set-up Holland with Xtrabackup on Redhat / CentOS. Let’s begin the execution. Installations for Holland Backup Framework on Ubuntu
Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz. To restore from the backup we used xtrabackup binaries and ran into issues following standard commands (assuming no changes): To prepare the backup I used apply-log as follows: $] innobackupex-1.5.1 –defaults-file=/usr/local/mysql/data/backup-my.cnf –apply-log /usr/local/mysql/data –ibbackup xtrabackup_51
Everybody knows the criticality of backup. You might have had your database dumped, data directory copied, flat files exported and even config and binary log files backed-up. But did you backup your MySQL user privileges? One can easily forget to backup the user privileges but it is much easier to do and you should backup your MySQL server user privileges / grants regularly. 1. Backup MySQL user privileges using mysqldump: $] mysqldump -uUSER -pPASS –databases mysql > mysql.sql
Creating scheduled backup using administrator is an easy task. Follow the GUI and you’re done. But I observed something different! MySQL Version: 5.0.83 Community MySQL Administrator: 1.2.17 Machine: Intel P4, Windows XP, Enough RAM 🙂 Logs: General, Error & irrelevant here though Slow query. Prologue: Administrator performs scheduled backup properly in normal scenario. What I was watching: Administrator’s Auto-Backup behaviour with windows Scheduler service and tracing steps out. Some facts: MySQL Administrator stores backup project’s details in <PROJECT-NAME>.mbd files in xml format under directory C:\Documents and Settings\<USER-NAME>\Application Data\MySQL Along with it it also adds a scheduled task with name <PROJECT-NAME>....