锐客网

  1. 首页 > 睿知 > it技术 > >

mysql怎么写备份脚本 mysql备份的几种方式

IT技术数据库

CentOS下备份MYSQL数据库一、编写备份脚本
【mysql怎么写备份脚本 mysql备份的几种方式】 二、更改备份脚本权限
chmod u+x /usr/local/tools/mysql_dy_backup.sh
三、设置定时执行脚本任务
crontab -e
30 22 * * * /usr/local/tools/mysql_dy_backup.sh
centos 6.5 mysql 自动备份数据库脚本怎么写#!/bin/bash
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin
export PATH
#数据库用户名
dbuser='root'
#数据库用密码
dbpasswd='********'
需要备份mysql怎么写备份脚本的数据库mysql怎么写备份脚本，多个数据库用空格分开
dbname='xiaohuai xiaohuai2'
#备份时间
backtime=`date +%Y%m%d%H%M%S`
#日志备份路径
logpath='/home/mysqlbak'
#数据备份路径
datapath='/home/mysqlbak'
#日志记录头部
echo ‘"备份时间为${backtime},备份数据库表 ${dbname} 开始"${logpath}/log.log
#正式备份数据库
for table in $dbname; do
source=`mysqldump -u ${dbuser} -p${dbpasswd} ${table} ${logpath}/${backtime}.sql` 2 ${logpath}/mysqllog.log;
mysql 自动备份脚本怎么写呀？网上的一些都用了不好使呀！用windowsmysql怎么写备份脚本的定时作务mysql怎么写备份脚本，写一个BAT文件执行备份处理 。
定时执行这个BAT就可以了 。
希望可以帮助你！
如果对我的回答满意，请点击我的回答下方选择满意回答按钮，谢谢
mysql的本地备份和双机相互备份脚本先修改脚本进行必要的配置 然后以root用户执行第一执行远程备份时先用 first参数本地备份用local参数 远程备份不用参数 注意1 注意:需要在另一主机上的Mysql用户用添加用户需要配置的地方: # define host and mysql passwordREMOTE_HOST= #远程主机名或IPREMOTE_PASSWORD= #远程主机的mysql中的root@本地主机 密码 # define database pathDB_PATH= /var/lib/mysql #本地mysql数据库路径LOCAL_PASSWORD= #本地mysql root用户密码DB_BACKUP_PATH= /root/db_bk #本地备份时数据保存的路径NO_BACKUP_DB= 设置本地数据库中不想备份的数据库名 用空格隔开直接下载 #!/bin/sh# mysqldump_all sh# this scripts is used to backup MySQL database beten tow MySQL SERVER!# define host and mysql passwordREMOTE_HOST= REMOTE_PASSWORD= # define database pathDB_PATH= /var/lib/mysql LOCAL_PASSWORD= DB_BACKUP_PATH= /root/db_bk # define which database no back up write db anme escap whit space!# example;# NO_BACKUP_DB= yns test ps_note # this said that if db name is yns or test or ps_note then not backup them!NO_BACKUP_DB= # get the database name and process one by oneecho Start to Backup ;#ls /var/lib/mysql/tmp/mydb allif [ $ != help ]; thenfor db in `ls $DB_PATH`; doif_backup= if [ d $DB_PATH/$db ] ; thenfor noBackDB in $NO_BACKUP_DB ; doif ( test $db = $noBackDB ); then#echo n ;if_backup= ;fidoneif [ $if_backup ]; thencase $ infirst)echo n Crate db [ $db ] on $REMOTE_HOST first! result=`mysqladmin h $REMOTE_HOST password=$REMOTE_PASSWORD create $db`if [ ! $result ]; thenecho Done! ;elseecho Fialed! check your configure plz! ;echo Remote host said: $result ;exitfi;;local)# back up to localhost dir if [ ! d $DB_BACKUP_PATH ]; thenmkdir $DB_BACKUP_PATHfiecho n [ $db ] Backup to local$DB_BACKUP_PATH with gzip ;if [ e $DB_BACKUP_PATH/$db gz ]; thenmv $DB_BACKUP_PATH/$db gz $DB_BACKUP_PATH/$db gz;fimysqldump password=Walte#Ming $db | gzip$DB_BACKUP_PATH/$db gzecho [OK] ;;*)# Do mon Backup!echo n [ $db ] Do Backup! ==== $REMOTE_HOST/$db ;mysqldump add drop table $db password=$LOCAL_PASSWORD | mysql h $REMOTE_HOST password=$REMOTE_PASSWORD $dbecho [OK] ;esacelseecho [ $db ] ;echo ***This database set to Not backup! Operation CANCELED! ;fielseecho [ $db ] ;echo ***Warning! Not a DataBbase Backup Canceled*** ;fidoneelseecho Usage: mysqldupm_all sh [firs|local|help] ;echo Some question ask for mailto: ;;fi# Ended all backup opretion!echo ;echo Note: if there is e wrong message white MySQLyou should check yourconfigure first! ;exit lishixinzhi/Article/program/MySQL/201311/29339

推荐阅读


上一篇：微信小程序.net开发，微信小程序用什么语言开发

下一篇：如何开启跨国电商，跨国电商怎么做的