Advertisement
Guest User

Untitled

a guest
Aug 11th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. innobackupex --user=root --password=**** --databases="db1" /path/to/basebackupdir --no-timestamp
  2.  
  3. innobackupex --incremental /path/to/incbackupdir --databases="db1" --incremental-basedir=/path/to/basebackupdir/ --user=root --password=**** --no-timestamp
  4.  
  5. innobackupex --apply-log --redo-only fullbackup
  6.  
  7. innobackupex --apply-log fullbackup --incremental-dir=/tmp/tmp_inc
  8.  
  9. innobackupex --apply-log --export fullbackup
  10.  
  11. mysql -uroot -p**** -e "DROP DATABASE IF EXISTS db1"
  12. mysql -uroot -p**** -e "CREATE DATABASE db1"
  13.  
  14. mysql -uroot -p**** db1 < db1.sql
  15.  
  16. cd /tmp/fullbackup/db1
  17. cp -R *.ibd /var/lib/mysql/db1
  18. cp -R *.cfg /var/lib/mysql/db1
  19.  
  20. service mysql restart
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement