Skip to content

Instantly share code, notes, and snippets.

@justinwhall

justinwhall/innobackupex.sql

Last active September 5, 2017 21:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save justinwhall/2cd53a9db6298def4db6033cec70d5b1 to your computer and use it in GitHub Desktop.
Save justinwhall/2cd53a9db6298def4db6033cec70d5b1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
innobackupex.sql
innobackupex $backup_path 2>>$log_file | pigz | /usr/local/bin/gpg2 –no-default-keyring –keyring /var/lib/mysql/backup_keyring.gpg –trust-model always –encrypt –digest-algo sha512 –cipher-algo aes256 –compress-level 0 –recipient REDACTED –recipient REDACTED | ssh $remote_user@$remote_server “cat > $remote_path/$date_path/FS_$backup_file” 2>>$local_err
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment