Automated MySQL Backups with innobackupex ( Percona Xtrabackup )

Install the latest xtrabackup

The main advantage of using xtrabackup to synchronize the nodes, is that the Donor is writeable during the synchronization process.
add the repository

Import the GP key

Install Xtrabackup and Percona-toolkit
Note: install netcat-openbsd fixes the error: nc: invalid option — ‘d’

install innobackupex scripts

5 replies
  1. nisutam
    nisutam says:

    Hi, how to use the script innobackupex-runner.sh to restore the database? Will you write some examples? Writes me an error: unknown type backup

    Reply
  2. minhhan
    minhhan says:

    file-run-innobackupex.sh Run perfectly!

    How can i Restore all my database with Script  innobackupex-restore.sh  

    Inside have a comment

    # Script to prepare and restore full and incremental backups created with innobackupex-runner.

    so run-innobackupex.sh ?

    when i run innobackupex-runner.sh
    [root@localhost bin]# sh /home/backupu1/innobackupex-runner.sh
    : command not foundbackupex-runner.sh: line 16:
    : command not foundbackupex-runner.sh: line 25:
    : command not foundbackupex-runner.sh: line 28:
    ‘home/backupu1/innobackupex-runner.sh: line 32: syntax error near unexpected token {
    'home/backupu1/innobackupex-runner.sh: line 32:
    usage() {

    Thanks you,

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *