mysql backup shell script

after the mysqldump commandmydump= "Mysqldump-u$myuser-p$mypass-s $SOCKET-x-f-r --events"Workaround 2: in mysqldump command, Font-family:verdana, Arial, Helvetica, Sans-serif; " add --events--ignore-table=mysql.events parameter mydump= "Mysqldump-u$myuser-p$mypass-s $SOCKET-x-f-r - -events--ignore-table=mysql.events "Error Reference Solution:http://www.linuxbrigade.com/warning-skipping-data-table-mysql-event/http://bugs.mysql.com/bug.php?id=

Tags: User name linux database MySQL Local Create a backup directory/bak/mysqlbak Writing Run scripts vim/home/bakmysql.shCode:#!/bin/bashBackupdir=/bak/mysqlbakTime= "$ (date +"%y%m%d%h%m ")"/usr/local/mysql/bin/mysqldump-u xxxx (user name)-pxxxx (password) XXXX (database name) | gzip > $backupdir/xxxx (Custom ID) $time. sql.gzFind $backupdir-n

#!/bin/bash#auto backup MySQL#xiaosu 2015-08-06User=rootpassword=123456dir_back=/data/' Date +%y%m%d 'Date= ' Date +%y%m%d 'Database=test#判断用户是否是管理员rootIf [$UID-ne 0];thenEcho-e "\033[32mthe script must use root\033[0m"Sleep 2ExitFi#判断备份目录是否存在if [!-D $DIR _back];thenMkdir-p $DIR _back;ElseEcho-e "\033[32mthe $DIR _back is exist\033[32m"Fi#备份数据库/usr/local/

Linux automatically backs up the MySQL database and uploads the shell script to the FTP server.#! /Bin/bash# Mysql autobackup shell### -------------- Set the mysql login parametersDbuser = rootDbpasswd =Dbserver = localhostDbname

(stderr) logging.info (' The database backup is complete ') def gettimepoint (days): " Returns the point in time that needs to be deleted ' Currtime = Time.time () DelTime = 3600*24*int (days) Timepoint = Currtime-deltime return T Imepoint def checkdir (cdir): "Delete folder function" ' Try:if os.path.isdir (cdir): Os.rmdir (Cdir) s = ' Remove dir%s succ ... '% cdir logging.info (s) except Exception as E:s = ' Remove D IR%s FAIL!!! %

backup, and the third is the executing program of the backup#Juge the exec user authorIf [$UID-ne 0];thenecho "must to is use the root for exec shell."ExitFi#以上的语句主要是用于判断是否用root用户执行#Juge If backup existsif [!-D $BAK _dir];thenMkdir-p $BAK _dirEcho-e "\033[32mthe $BAK _dir creat successfully!\033[0m"Elseecho "This $BAK

On the Internet to read a few scripts based on the Internet slightly modified under, slightly more prepared point, is missing something#!/bin/bash# Large Backup number backup_max_files=20# database backup directory working_dir=$ (dirname "$") Export working_dir=$ (cd-p "$WORKING _dir"/ >/dev/null; PWD) #数据库IP地址, account number, password db_host= "XXXXXXX" db_user= "XXXXXX" db_password= "XXXXXXX" #需要备份的数据库Da

Tags: mysql#!/bin/bash #Time: 2016-11-8 #owner: Fujinzhou #scriptname: mysqlback.sh #要备份的数据库名, multiple databases separated by spaces db= (Zabbix reboot10) #备份目录 backuppath= "/data/backup/" if [!-D "$BACKUPPATH"]; then mkdir-p "$Backuppath " fi #循环DB for DB in ${db[*]} do cd $BACKUPPATH #备份并打包数据库生成的sql文件 /bin/nice-n 19/usr/bin/mysqldump--defaults-file=/root/.my.cnf $db > ${db}_$ (Date +%y%m%d). SQL Tar zPc

Tags: sql elf usr UI roo backup source SQL database RACCreate the shell script Topjui_source.exp, which reads as follows:#!/usr/bin/expect Spawn echo "###### running ... ######" spawn echo $argv 0 Spawn echo $argv 1 set timeout Spawn mysql-uroot-p123456 set timeout expect { "hi" {send "you said hi\n"} "Hello" {send

MySQL database remote backup data preferably packed and compressed[Email protected] crontab]# pwd/data/mysql_bakup/crontab[email protected] crontab]# cat backup_db_wangshibo.sh#!/bin/bashMysql= "/usr/bin/mysql"mysqldump= "/usr/bin/mysqldump"Backup_dir= "/data/mysql_bakup"#DB_SOCKET = "/var/lib/mysql/mysql.sock"Db_hostn

Touch mysql_backup.shchmod +x mysql_backup.shVim mysql_backup.sh#!/bin/bashId= "Root"Pwd= "123456"dbs= "Test Rockoa"Backuppath= "/root/mysqlbackup" backup path self-settingDay=15[!-D $backpath] mkdir-p $backuppathCD $backuppathbackupname=mysql_$ (Date +%y-%m-%d)for DB in $dbs;DoMysqldump-u$id-p$pwd-s/var/lib/mysql/mysql.sock $db > $backupname _$db.sqlIf ["$?" = = "0"]Thenecho $ (date +%y-%m-%d) "$db mysqldu

#!/usr/bin/env python# Encoding:utf-8Import Os,time,sysBakup_dir = '/home/bak/mysql 'Current_time = Time.strftime ('%y%m%d%h%m%s ')user = ' root 'Password = ' root 'Database = [' MySQL ', ' aaa ']If Os.path.exists (bakup_dir):Print "The path%s exists"% Bakup_direlse:Os.makedirs (Bakup_dir)Print "The path%s create sucessful"% Bakup_dirOs.chdir (Bakup_dir)For I in range (len):A = Database[i]Mysqlbak_cmd = "my

#!/bin/bash#file:mysql_backup.sh#date2016-1-9backdes=/data/msyql_back/' date+%Y-%m-%d ' //Create the directory that holds the backup data backname= ' date+%y-%m-%d ' //backup name, You can omit the database=test//backed up database mysqluser=root// The user name at the time of backup #mysqlsec=//the password at the time of b