shell_backup_MySQL
#!/bin/bash
#可修改如下参数
backup_filename=$(date +%Y%m%d%H%M%S)
backup_tmp_dir=/data/backup/
ip=10.0.1.182
user=root
passwd=starcor
databse_1=nn_core
databse_2=nn_cms
#备份目录
if [ ! -d ${backup_tmp_dir}/cms/db ]; then
mkdir -p ${backup_tmp_dir}/cms/db
fi
if [ ! -d ${backup_tmp_dir}/core/db ]; then
mkdir -p ${backup_tmp_dir}/core/db
fi
#备份
function data() {
/usr/local/mysql/bin/mysqldump -u$user -p$passwd -h127.0.0.1 $databse_1 --skip-lock-tables > ${backup_tmp_dir}/core/db/db_${databse_1}_${ip}_${backup_filename}.sql
/usr/local/mysql/bin/mysqldump -u$user -p$passwd -h127.0.0.1 $databse_2 --skip-lock-tables > ${backup_tmp_dir}/cms/db/db_${databse_2}_${ip}_${backup_filename}.sql
}
function package(){
#打包文件
cd ${backup_tmp_dir}/core/db
tar zcf db_${databse_1}_${ip}_${backup_filename}.sql.tar.gz db_$databse_1_$ip_${backup_filename}.sql
find ./ -name "*.sql" -exec rm -rf {} \;
cd ${backup_tmp_dir}/cms/db
tar zcf db_${databse_2}_${ip}_${backup_filename}.sql.tar.gz db_$databse_2_$ip_${backup_filename}.sql
find ./ -name "*.sql" -exec rm -rf {} \;
}
data
package
#保存7天备份文件
find /data/db_backup -type f -mtime +7 -exec rm -rf {} \;
最新文章
- AssetBundle loading failed because.....已解决
- 在Xcode6.4中使用OpenCV
- 2016.07.14,英语,《Vocabulary Builder》Unit 25
- LZMA demo挑选使用备忘
- Hive cli源码阅读和梳理
- Swift弹窗
- Volley HTTP库系列教程(1)简介及优点
- linux查看cpu、内存信息
- Android(java)学习笔记199:Android中补间动画(Tween Animation)
- FE: Responsive Web Design Overview
- NHbiernate 配置
- java中文乱码问题
- 推荐系统 LFM 算法的简单理解,感觉比大部分网上抄来抄去的文章好理解
- Python网络编程篇之socket
- 远程SCP报错,报22号口错误
- MyBatis的三层级联和二层缓存
- kmp循环节
- solr 字段设置不存储表示不会进行分词
- Jaxb 完全手册
- svn在commit后报错:is scheduled for addition, but is missing
热门文章
- 在Linux下 MySQL错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 解决办法【很管用】
- html5有哪些新特性、移除了那些元素?
- pycharm 的 使用 设置智能目录 Pycharm 断点跳转及 Step Over/Step Into/Step Out 等的区别
- 面试题:你使用过concurrent包下的那些类?
- (转)ERROR : The processing instruction target matching ";[xX][mM][lL]"; is not allowed.
- Springmvc接收数组参数
- Centos配置NAT模式下的静态ip
- Linux ES集群服务配置说明
- python装饰器类
- 吴裕雄--天生自然 PHP开发学习:MySQL子句