mysql backup shell script

Note: here I want to back up the pw85 database under the/var/lib/MySql database directory to the compressed file format of/home/snapshot (2012_04_11 refers to the date on which the backup was executed ), at last, only the backups of the last 7 days are retained. Implementation steps: 1. Create a directory for saving the backup file:/home/mysql_datacd/home Note: H

MySQL backup script for database/table sharding 1. Database shard backup: #! /Bin/sh MYUSER = root MYPASS = 123456 SOCKET =/data/3306/mysql. sock MYLOGIN = "mysql-u $ MYUSER-p $ MYPASS-S $ SOCKET" MYDUMP = "mysqldump-u $ MYUSER-p

Tags: Linux OPS linux operations engineer1) Prepare test data: Build a table and insert test data in bulk by writing scripts.[email protected] scripts]# cat ceshi.sh#/bin/bashPath= "/usr/local/mysql/bin: $PATH" #定义mysql命令所在路径Myuser=root #定义数据用户名Dbpath=/server/backup #定义数据备份目录mypass=xiwei1995 #定义数据用户密码Socket=/tmp/mysql.sock #定义数据库sock文件, specifying the correspondi

Optimize the shell script bitsCN.com of the Mysql data table because the data volume in the company database is large, optimize the data table in the company's mysql database on a regular basis (the optimize description is as follows ), there are more than 300 data tables in the database. manual operations are obviousl

#!/bin/bashbakdir=/home/webdata/mysqlbackup/mysqlbackup_log/bindir=/home/mysql/var/Logfile=/home/webdata/mysqlbackup/mysqlbackup_log/bak.logBinfile=/home/mysql/var/mysql-bin.indexMysqldump-udearedu-p--lock-tables--flush-logs--master-data=1 vkt >/home/webdata/mysqlbackup/mysqlbackup_log/ Vkt.backup# # # Refresh the log, generate a new log and copy it to the approp

Common operations are performed on monitor1, but the data on monitor2 must be updated at any time. However, when the interval is large, it is irrelevant that the script requires local backup and remote backup, at the same time, some data updated by monitor2 is stored. The detailed script code for Nagios

The script is placed in the/home/user/mysql_backup.sh Crontab # crontab-l # m H Dom Mon Dow command * * */home/user/mysql_backup.sh The script is as follows Copy Code code as follows: #!/bin/sh # mysql_backup.sh:backup MySQL databases and keep newest 5 days backup. # # Last updated:20 March 2006 # ----

The importance of Web site backup, believe that every webmaster is know, and now most stationmaster, have used the VPS host, in the Linux operating system, the VPS data backup main is, the website file, the database, the domain name configuration and so on, like the tribe is uses the military elder brother a health installs the package, the operation basically is identical. Here, we mainly use the

Note: Here I want to back up the pw85 database under the/var/lib/MySql database directory to the compressed file format of/home/snapshot (2012_04_11 refers to the date on which the backup was executed ), at last, only the backups of the last 7 days are retained. Steps: 1. Create a directory to save the backup file:/home/mysql_dataCd/home # enter the DirectoryMkd

Share a self-written mysql automatic backup script, timed execution settings, and windows automatic FTP. Please advise. Prerequisites: vsftpd is enabled for the mysql database server and an appropriate account is configured for the Intranet storage server. Share a self-written mys