mysql backup shell script

Tags: mysql record databases#!/bin/bash#记录备份的时间echo "-----" $ (date + "%y-%m-%d%h:%m:%s") "-----" >>/data/backup_mysql/record.log#定义变量Myuser=rootmypassword=29749716# @HeiniaoSocket=/data/mysql/mysql.sockmycmd= "Mysql-u $MYUSER-p$mypassword-s $SOCKET"mydump= "Mysqldump-u $MYUSER-p$mypassword-s $SOCKET"Backupdir=/data/backup_mysql#正式备份For DB in ' $MYCMD-e ' show da

as follows: */10 * * * * root/bin/sh/root/mysql_slave.sh Remember in each MySQL from the machine to allocate a Yuhongchun user, the permission is not OK, only limited to run locally, as follows: Copy Code code as follows: Grant all privileges on *.* to "Yuhongchun" @ "127.0.0.1" identified by "yuhongchun101"; Grant all privileges on *.* to "Yuhongchun" @ "localhost" identified by "yuhongchun101";

This article is mainly about how to use the shell to achieve a full amount of MySQL, incremental backup. Incremental backups are replicated mysql-bin.00000* to the specified directory at Monday-Saturday 3 o'clock in the morning, while full backups use mysqldump to export all of the databases, hold every Sunday 3 o'cloc

Back up mysql database bitsCN.com using shell scripts Back up mysql databases using shell scripts Requirement Sort out some script programs near the end of the year and share with you a script for

There are many ways to back up a database. the most common method is automatic and scheduled Database Backup. next I will introduce how to use shell scripts in linux to back up a MySQL database regularly. There are many ways to back up a database. the most common method is automatic and scheduled Database Backup. next

#!/bin/bash############################### #FileName: Backuplogtimer.SH#Function: Scheduled backup log file #version:0.1#Authon: xueya#date:2014.06. -############################### #获取当前路径path=`pwd`Echo "current1 path: ${path}"#循环执行 while[[1-eq1 ]] Do#查看文件夹下的文件 fileList=`ls 2>/dev/NULL' #遍历此文件夹下的文件 forPFileinch$fileList Do Echo "Current path: ${path}/${pfile}"#判断是否属于文件夹if[[-D"${pfile}"]]; Then#计算文件夹数量 Num=`ls-L./tmp|grep "^d"|WC-l ' #判断文件数是否超过了

"——————————————-" >> $LogFile Example 2. If you are dissatisfied with the above script, refer to the MySQL database backup script below. The code is as follows Copy Code #!/bin/bash #Mysql autobackup

In the past, the company used a Shell script to automatically back up MySQL to FTP on the Internet, which has always been used well. But the problem is that as the number of backup files increases, it is inconvenient to regularly clean up the old backup files on FTP. In fact

= "Innobackupex--user=%s--password=%s--no-timestamp--incremental%s--incremental-basedir=%s"% (Backuser,backpass,increment_dir,increbase_dir)Subprocess.call (Commandincre,shell=true)Logging.info (Commandincre)if __name__ = = ' __main__ ':Backup ()Cleanstore () MySQL management uses xtrabackup for hot standby http://www.linuxidc.com/Linux/2014-04/99671.htm

#!/bin/bashcd= ' df-l |awk ' nr==3 {print $4} ' |awk ' BEGIN {fieldwidths= ' 2 1 "} ' {print '} 'If [$CD-ge 20];thenecho " hard disk space is full and cannot be backed up " | Mutt-s " backup alarm, please replace the hard drive in time " [Email protected] exit 1FiLogrotate-f/etc/logrotate.confTar zcf/opt/backup/' Date +%y%m%d%h%m '. tat.gz/var/log/messages.* >/dev/nullRt= ' echo $? 'If [$RT-eq 0];thenecho "

Mysql automatic backup script bitsCN.com in linux Put the script in/home/user/mysql_backup.sh Crontab # Crontab-l # M h dom mon dow command 28 16 ***/home/user/mysql_backup.sh The script is as follows: #! /Bin/sh # Mysql_backup.sh: backu