Not the answer you need?
Register and ask your own question!

innobackupex backup

saifuddinsaifuddin EntrantInactive User Role Beginner
Help write a script 3
1. Create a full backup
2. create an incremental backup
3. Restore backup

1. script

innobackupex --user=root --password=test --no-timestamp /root/backup/full/
innobackupex --apply-log /root/backup/full/
innobackupex --apply-log --redo-only /root/backup/full/

2. script

innobackupex --incremental --user=root --no-timestamp --password=test /root/backup/inc --incremental-basedir=/root/backup/full
innobackupex --apply-log --incremental /root/backup/full --incremental-basedir=/root/backup/inc
innobackupex --apply-log --redo-only --incremental /root/backup/full --incremental-basedir=/root/backup/inc

3. script
cd /root/dumpdb/

service mysql stop
rm -rf /var/lib/mysql/*

innobackupex --defaults-file=/etc/mysql/my.cnf --copy-back /root/dumpdb
chown mysql:mysql -R /var/lib/mysql
chmod 770 -R /var/lib/mysql
service mysql start

rm -rf /root/dumpdb/*

1 and 3 working

2 does not work. help me
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.