xtrabackup 使用
创建具有完全备份所需的最小权限的数据库用户的SQL示例如下
mysql> CREATE USER 'bkpuser'@'%' IDENTIFIED BY 's3cret';
mysql> GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT ON *.* TO
'bkpuser'@'localhost';
mysql> FLUSH PRIVILEGES;
OTHER CONNECTION OPTIONS
According to your system, you may need to specify one or more of the following options to connect to the server:
Option Description
–port The port to use when connecting to the database server with TCP/IP.
–socket The socket to use when connecting to the local database.
–host The host to use when connecting to the database server with TCP/IP.
# Start a server to send backups when requested by peers.
exec ncat --listen --keep-open --send-only --max-conns=1 3307 -c \
"xtrabackup --backup --slave-info --stream=xbstream --host=127.0.0.1 --user=${MYSQL_REPLICATION_USER} --password=${MYSQL_REPLICATION_PASSWORD}"
xtrabackup --defaults-file=/etc/mysql/my.cnf --stream=xbstream --host=192.168.25.31 –-port=30307 --user=bkpuser --password=s3cret --backup
innobackupex --user = DBUSER --password = SECRET / path / to / backup / dir /
innobackupex --user = LUKE --password = US3TH3F0RC3 --stream = tar ./ | bzip2 -
最新文章
- PL/sql使用总结
- 【30集iCore3_ADP出厂源代码(ARM部分)讲解视频】30-3 底层驱动之LED_蜂鸣器
- mybatiGenerator
- Image.FrameDimensionsList 属性备注
- UVALive 4128 Steam Roller(最短路(拆点,多状态))
- Mac: the original hosts
- Android状态栏颜色修改
- D.6661 - Equal Sum Sets
- Fusioncharts图表组件API参考方法(Functions)汇总篇(续)
- java模拟一个抽奖程序
- nginx配置前端代理
- JAVA IO练习
- 关于dom&;bom
- Spine用于Timeline(NullReferenceException: Object reference not set to an instance of an object pine.Unity.Editor.AnimationReferenceAssetEditor.OnInspectorGUI ())
- Logic and Proofs--离散数学
- 【python】re库 正则的一些过滤和把str拆分成list案例 以及json dict类型
- 第35章:MongoDB-集群--Master Slave(主从复制)
- linux中的signal机制(转)
- eclipse向svn提交代码的时候忽略部分资源配置
- 安装RabbitMq-----windows