Tags: mysql backupI believe that many of the small partners will use the MySQL database, the following provides a script to share with gentlemen.#!/bin/bashscript_dir=$ (dirname)Backup_dir= "/data1/mysqlbackup"backup_days=480RM-RF ${backup_dir}/*db_ip= '/sbin/ifconfig-a|grep inet|grep-v 127.0.0.1|grep-v Inet6|awk ' {print $} ' |tr-d ' addr: ' |head-1 'Backup_type= ' Xtra_full 'For i in ' Ps-ef |grep port= |grep-v grep|cut-d "="-F 10 'Dodb_port= $iNew_
Mysqldump full backup shell script sharing today, the tester urged that the relevant bug database data must be backed up, and the full backup should be performed on a daily basis; for this database with a small amount of data, I feel that it is not necessary to become a mentor so that I can develop two sets of solutions for maintenance at the same time! However,
Scripting features: Periodically make a full backup of some items.The Project.lst file format is as follows:Project1Project2The backup script is as follows:#!/bin/sh## Subversion Data Backup script# by Scud Http://www.jscud.com# 2005-11-27## Subversion full
Simple Web Site Backup script
The code is as follows
Copy Code
#!/bin/bash#backup DatabaseMypw=cactieznewtime=$ (Date +%y%m%d)if [-d/var/www/backup/];thenMysqldump-u ROOT-P$MYPW DB >/var/www/backup/$newtime-database.sqlElsemkdir/var/www/
Share your own linux backup script (webdata + mysql) the function is used with crontab to automatically back up the website directory and mysql local copy ftp copy mailbox copy local and ftp automatically delete 3 days ago linux requires sendmail and ftp if not available set your own information when installing and using yum.#! /Bin/bash www.2cto.com # function: automatic
Tags: Execution time thinking error etc script rom mkdir grepShare a MySQL sub-library backup script (original) Development ideas: 1. Path: Specify the location of the backup, the path (the first to determine whether there is no creation of a directory) first defined, my path:/mysql/
Backup is the most important. Many test environments are built on windows, and there is one on the master's computer. to ensure its security, it is decided to perform regular backup. The example shows how to use scripts + windows scheduled tasks in windows to periodically execute full backup. Backup
Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix platform using shell implementation is very simple, But ran to win inside, became vexed, not because of the trouble, but because the use of less people, do not know how to deal with the matter, I wrote a simple implementation of the basic function of w
1. File backup scriptFunction: Use this script to backup files, directories in the system, the backed up files are compressed in gzip, and date to mark the date of backup, the name of the backup file or directory is written down to the log file for viewing.The
MySQL backup script based on Innobackupex
Innobackupex is part of Xtrabackup, and its essence is to call xtrabackup. The main difference is that Xtrabackup not only supports the innodb engine, but also supports the xtradb engine. This article mainly encapsulates Innobackupex to shell scripts for regular backup for your reference.
1.
This script was found online in and used in the official system after modification. The database name was changed to LinuxIDC.com.
1. Create a sh file and create a script file named mysqlscript. sh in/usr/bin/. For details, see mysqlscript. sh.
2. Open # crontab-e in the root directory and enter 12 12 ***/usr/bin/mysqlscript. sh
3. Finally, if you find that the script
Tags: database mysql article backupThis article focuses on how to use the shell to achieve full MySQL, incremental backup. Incremental backups replicate mysql-bin.00000* to the specified directory in Monday-Saturday 3 o'clock in the morning, while full-scale backups use mysqldump to export all databases, every Sunday 3 o'clock in the morning, and delete the mysq-bin.00000* left last week. The backup operati
This is a production database's rman backup shell script, divided into zero-level backup and one-level differential cumulative backup, zero-level backup once a week, and other one-level differential cumulative backup.
1. Zero-leve
----------------------------------------------------------------------------
---- This is andkylee's personal originality. Please repost it with respect to the author's Labor achievements;
---- The original output must be specified for reprinting.Location:Http://blog.csdn.net/andkylee
---- Keywords: ASE database backup Automatic Continuous backup delete old backup
Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix platform using shell implementation is very simple, But ran to win inside, became vexed, not because of the trouble, but because the use of less people, do not know how to deal with the matter, I wrote a simple implementation of the basic function of w
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.