Hear Xtrabackup open source and powerful
2018-03-06 11:54:41
The latest version of 2.4.9 is installed on the official website.
Online articles are used Innobackupex, but the latest version has been abandoned, look at the manual "Percona-xtrabackup-2.4.9.pdf"
Simple test
Backup smooth
# xtrabackup--user=root--password=root--backup--target-dir=/home/gp/bak/--databases=xswb_90output: ... Xtrabackup:transaction Log of LSN (5387694471) to (5387694471) was copied. 180306 One:: Completed ok!
Recovery failed
# xtrabackup--copy-back--target-dir=/home/gp/bak/
2.4. 9 5.7. - /usr/local/mysql/var is not empty!
The target directory will be empty.
Note the precautions in the manual
The restored database directory must be empty, and the recommended mysqld is the off state.
So many database operation is more complex, restore to a new directory, and then modify the my.conf point to this directory, some cumbersome did not continue to try
MySQL Xtrabackup preliminary interview