MySQL Backup setup, automation using Holland, mysqldump on Ubuntu
Kedar
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…
Browsing Tag
backup configuration
2 posts
Setup and configure MySQL backup using Holland and Xtrabackup
Setting up a database backup is a primary task for database administrators and we see perl and shell scripts wrapped around few of the backup-tools in practice. With right tools…
4 responses to “Setup and configure MySQL backup using Holland and Xtrabackup”
It doesn’t work for mysql 8 giving error for unkown option —no-time-stamp
Hi Mughees,
So I checked this and you’re right but then you must be on older version. Yum repo is only available with 1.1.22 which has the bug. This has been fixed in latest release
https://github.com/holland-backup/holland/releases/tag/v1.2.10
Until that becomes available through repo, consider using the source compile.
After following these instructions as written, I’m getting the error:
Backup failed: Failed to find innobackupex script
Is this option required? If so, where can I find the script?
Hi Steve!
Innodbackupex is the part of the xtrabackup solution. I did not include the setup instruction for that but you can simply try:
yum OR apt-get install percona-xtrabackup
alternatively you can grab the binary and set-it-up (https://www.percona.com/downloads/XtraBackup/)
Once that is done you should be fine!
Regards,
Kedar.