Xtrabackup full backup
来源:互联网 发布:网络招聘文员好做吗 编辑:程序博客网 时间:2024/05/22 03:53
Step:
create full backup:
innobackupex --defaults-file=/etc/my.cnf --user=root --password=mysql /tmp/backup
shutdown mysql:
mysqladmin -uroot -p'mysql' -S /tmp/mysql.sock shutdown
prepare:
innobackupex --defaults-file=/etc/my.cnf --apply-log --redo-only /data/backup/full/2011-06-17_12-04-51 --user=root --password='mysql'
recover:
innobackupex --defaults-file=/etc/my.cnf --copy-back /tmp/backup
startup mysql:
mysqld_safe --defaults-file=/etc/my.cnf &
NOTES:
[root@SLAVE bin]# innobackupex --defaults-file=/etc/my.cnf --copy-back /tmp/backup
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex
prints "completed OK!".
sh: xtrabackup: command not found
innobackupex: fatal error: no 'mysqld' group in MySQL options
innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options
SOLUTION:
ln -s /tmp/xtrabackup-1.6.5/mysql-5.1/storage/innobase/xtrabackup/xtrabackup_51 /usr/local/mysql/bin/xtrabackup
- Xtrabackup full backup
- Greenplum full backup
- rman full backup 恢复示例
- full backup of Linux OS
- Mysql xtrabackup 之creating a backup
- MySQL Using xtrabackup backup and recovery example
- Restoring a Full Backup with innobackupex
- backup mysql for xtrabackup with xbstream and lz4
- XtraBackup
- XtraBackup
- xtrabackup
- xtrabackup
- XtraBackup
- full backup and log backup can happen at the same time
- xtrabackup 备份mysql数据库三:partial backup 部分备份及恢复
- backup
- BACKUP
- backup
- C# 背景设置
- Android中把文件存放在SDCard
- margin属性
- SCOPE_IDENTITY
- spring AOP @Around @Before @After 区别
- Xtrabackup full backup
- 全球品牌百强:苹果继续风骚,中移动贬值18%
- TicTacToe project submition
- 常用贴片电阻、电容、电感封装
- MySQL缓冲和无缓冲查询对比
- H264编码器参数理解 (部分)“I帧”和“帧间距”等的理解
- How to Convert An audio From m4a to pcm
- 23.windbg-dv(显示局部变量)
- android按钮被点击文字颜色变化效果