mysqldump gzip

最新推荐文章于 2023-08-28 09:38:34 发布

大大柳树

最新推荐文章于 2023-08-28 09:38:34 发布

阅读量255

点赞数

分类专栏： Mysql 文章标签： SQL Mobile BBS

Mysql 专栏收录该内容

51 篇文章 0 订阅

订阅专栏

mysqldump sms | gzip > sms.sql.gz



/usr/local/services/mysql5.1.57/bin/mysqldump --opt --default-character-set=utf8 gongwuyuan | gzip > /data1/mysqldata/mysqlbackup/gongwuyuan.`date +%Y%m%d`.sql.gz


mysqldump -h10.1.20.8 -uxxx69 -pxxxx --opt --default-character-set=utf8 --add-drop-database --databases ask_591up mobile_edu > d:/sql/edu.backup.sql


SELECT CONCAT('lock tables ', TABLE_SCHEMA,'.',table_name ,' read ;') AS ff FROM information_schema.TABLES WHERE TABLE_SCHEMA IN('ask_591up','bbs_edu','edu_591up_pay','jg_591up','mobile_edu')


#!/bin/sh
/usr/local/services/mysql5.1.57/bin/mysqldump --opt --default-character-set=utf8 gongwuyuan | gzip > /data1/mysqldata/mysqlbackup/gongwuyuan.`date +%Y%m%d`.sql.gz  

crontab
0 3 * * * /data1/mysqldata/monitor/mysqldump.sh