warning: percona-xtrabackup-2.3.2-1.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY

Preparing... ? ? ? ? ? ? ? ?########################################### [100%]

? ?1:percona-xtrabackup ? ? ########################################### [ 33%]

? ?2:percona-xtrabackup-test########################################### [ 67%]

? ?3:percona-xtrabackup-debu########################################### [100%]

?

? ----安装成功！！！

? ?

[root@rh64 XtraBackup]# man innobackupex

INNOBACKUPEX(1) ? ? ? ? ? ? ? Percona XtraBackup ? ? ? ? ? ? ? INNOBACKUPEX(1)

NAME

? ? ? ?innobackupex - innobackupex Documentation

?

? ? ? ?The ?innobackupex ?tool is a Perl script that acts as a wrapper for the xtrabackup C program. It

? ? ? ?is a patched version of the innobackup Perl script that Oracle distributes with the ?InnoDB ?Hot

? ? ? ?Backup tool. It enables more functionality by integrating xtrabackup and other functions such as

? ? ? ?file copying and streaming, and adds some convenience. It lets you perform point-in-time backups

? ? ? ?of ?InnoDB ?/ ?XtraDB tables together with the schema definitions, MyISAM tables, and other por-

? ? ? ?tions of the server.

? ? ? ?This manual section explains how to use innobackupex in detail.

PREREQUISITES

? ?Connection and Privileges Needed

? ? ? ?Percona XtraBackup needs to be able to connect to the database server and perform operations ?on

? ? ? ?the ?server ?and ?the ?datadir when creating a backup, when preparing in some scenarios and when

? ? ? ?restoring it. In order to do so, there are privileges and permission requirements on its ?execu-

? ? ? ?tion that must be fulfilled.

? ? ? ?Privileges ?refers ?to ?the ?operations ?that ?a ?system user is permitted to do in the database

? ? ? ?server. They are set at the database server and only apply to users in the database server.

? ? ? ?Permissions are those which permits a user to perform operations on the ?system, ?like ?reading,

? ? ? ?writing ?or ?executing ?on a certain directory or start/stop a system service. They are set at a

? ? ? ?system level and only apply to system users.

? ? ? ?Whether xtrabackup or innobackupex is used, there are two actors involved: the user invoking the

? ? ? ?program ?- ?a ?system ?user - and the user performing action in the database server - a database

? ? ? ?user. Note that these are different users in different places, even tough they may have the same

? ? ? ?username.

? ? ? ?All the invocations of innobackupex and xtrabackup in this documentation assumes that the system

? ? ? ?user has the appropriate permissions and you are providing the relevant options ?for ?connecting

? ? ? ?the database server - besides the options for the action to be performed - and the database user

? ? ? ?has adequate privileges.

? ?Connecting to the server

? ? ? ?The database user used to connect to the server and its password are specified by the --user and

? ? ? ?--password option,

? ? ? ? ? ?$ innobackupex --user=DBUSER --password=SECRET /path/to/backup/dir/

? ? ? ? ? ?$ innobackupex --user=LUKE ?--password=US3TH3F0RC3 --stream=tar ./ | bzip2 -

? ? ? ? ? ?$ xtrabackup --user=DVADER --password=14MY0URF4TH3R --backup --target-dir=/data/bkps/

?