大家有没用过xtrabackup 中的innobackupex,我本来测试单独备份某个数据库,但是备份不了,备份的是所有的数据库。
我查看了一下那个帮助 --databases=LIST
This option is used to specify the list of databases that
innobackup should backup. The list is of the form
"db_name[.table_name] db_name1[.table_name1] ...".
If this option is not specified all databases containing
MyISAM and InnoDB tables will be backed up.
Please make sure that --databases contains all of the
innodb databases & tables so that all of the innodb .frm
files are also backed up. In case the list is very long,
this can be specified in a file and the full path of the
file can be specified instead of the list.
里面有这个参数,但是我加了不起作用。sudo ./innobackupex-1.5.1 --user=backupuser --password=backup --defaults-file=/etc/my.cnf --database=test --socket=/data/mysql/mysql.sock --stream=tar /data/backup/ | gzip > /data/backup/bak_test.tar.gz
我查看了一下那个帮助 --databases=LIST
This option is used to specify the list of databases that
innobackup should backup. The list is of the form
"db_name[.table_name] db_name1[.table_name1] ...".
If this option is not specified all databases containing
MyISAM and InnoDB tables will be backed up.
Please make sure that --databases contains all of the
innodb databases & tables so that all of the innodb .frm
files are also backed up. In case the list is very long,
this can be specified in a file and the full path of the
file can be specified instead of the list.
里面有这个参数,但是我加了不起作用。sudo ./innobackupex-1.5.1 --user=backupuser --password=backup --defaults-file=/etc/my.cnf --database=test --socket=/data/mysql/mysql.sock --stream=tar /data/backup/ | gzip > /data/backup/bak_test.tar.gz
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货