Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- innobackupex --user=root --password=**** --databases="db1" /path/to/basebackupdir --no-timestamp
- innobackupex --incremental /path/to/incbackupdir --databases="db1" --incremental-basedir=/path/to/basebackupdir/ --user=root --password=**** --no-timestamp
- innobackupex --apply-log --redo-only fullbackup
- innobackupex --apply-log fullbackup --incremental-dir=/tmp/tmp_inc
- innobackupex --apply-log --export fullbackup
- mysql -uroot -p**** -e "DROP DATABASE IF EXISTS db1"
- mysql -uroot -p**** -e "CREATE DATABASE db1"
- mysql -uroot -p**** db1 < db1.sql
- cd /tmp/fullbackup/db1
- cp -R *.ibd /var/lib/mysql/db1
- cp -R *.cfg /var/lib/mysql/db1
- service mysql restart
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement