sqlbak

Label:Creating a BAT file You need to put 7z.dll and 7z.exe in the bat's sibling directory and Mysqldump.exe these 3 files Echo off CLS CD/D%~dp0REM===========configure (start) ============== Sethost=127.0.0.1 SetUser=AdminSetpass=Configure your MySQL passwordSetDbname=the name of the database to be backed upREM===========configure (end) ==============REMSet-date-and-time-toymd-and-his Set"ymd=%date:~,4%%date:~5,2%%date:~8,2%"Seth=% Time: ~0,2% SetH=%h: =0% Set"his=%h%%time:~3,2%%time:~6,2%"Echo

Here is the script implementation process:1. Automatically package the backup on the server to a Web directory (of course this web directory is inaccessible to other people), so that the script to download.2. Download the backup package on the local server, unzip it and copy it into a dedicated backup directory.3. When the above two steps are completed, we will remove the backup package on the server to avoid leakage. Here's the script:1. This is to filter out the latest backup on the server an

The original script: The code is as follows Copy Code #!/bin/bashFile= "/root/newfile/"List= "/root/sqlbak"Ls-l $list/|awk ' {print $} ' |while read lineTodoCp-r $list/$line $fileDone Modified script: The code is as follows Copy Code #!/bin/bashFile= "/root/newfile/"List= "/root/sqlbak"Ls-l $list/|grep-v Total|awk ' {print $} ' |while read

Recently the World Cup has come, has been busy between work and the World Cup, there is no time to manage my blog, today can only be the whole simple small shell to everyone. The company asked to delete one months before the backup file, so that the hard drive to the whole explosion, on the server looked down, incredibly have 3 months of backup did not clean up, Fortunately, SQL backup, otherwise hard disk space is already full. Here is my solution: Copy Code code as follows: Cat del

Recently the World Cup has come, has been busy between work and the World Cup, there is no time to manage my blog, today can only be the whole simple small shell to everyone. The company asked to delete one months before the backup file, so that the hard drive to the whole explosion, on the server looked down, incredibly have 3 months of backup did not clean up, Fortunately, SQL backup, otherwise hard disk space is already full. Here is my solution: Cat delbak.sh #!/bin/sh location= "/root/

Shell deletes objects before a specified time.Since the recent World Cup, I have been busy with work and the World Cup, and I have no time to manage my blog. Today, I can only give you a simple little shell. the company asked to delete the backup file one month ago, so that the hard disk would not be cracked. After reading the file on the server, the backup files for three months had not been cleared, fortunately, it is SQL backup, or the hard disk space will be full long ago.The following is my

. Declare @ filedir varchar (200), @ dir varchar (200)Declare @ dbname varchar (50), @ bakname varchar (50), @ SQL varchar (4000)Select @ filedir = filename from sysfilesSet @ dir =''While charindex ('\', @ filedir) BeginSet @ dir = @ dir + Left (@ filedir, charindex ('\', @ filedir ))Set @ filedir = substring (@ filedir, charindex ('\', @ filedir) + 1, Len (@ filedir)-charindex ('\', @ filedir ))EndSet @ bakname = 'bak' + Cast (datepart (weekday, getdate ()-1 as varchar (1 ))----- Specify Dat

TemplateCat delbak.sh#!/bin/shlocation= "/root/sqlbak/"Find $location-mtime +30-type f |xargs rm-fPs:Location is the directory where the lookup is set--mtime +30 is set time is 30 days ago-type F this week the type of lookup is fileThen add crontab timing to delete:Crontab-l4 1 * */bin/sh/root/soft_shell/delbak.shSet to 1th on every month. 4:10 execute the script. Of course, you can do it according to your own needs.The same deletion method:Find/root/

original weekly down data back, but also manually to down data is the latest backup on the server, OK, in order to meet this requirement, I made some changes in the original script. Manual Down Data script: The code is as follows Copy Code #!/usr/bin/expect-fSet Timeout-1Set passwd passwdSpawn ssh-p18330 root@72.11.x.xExpect {"Yes/no" {send "YESR"; Exp_continue}"Password:" {send "$PASSWDR"}}Expect "*#*" {send "Sh/root/soft_shell/copy_newfile.shr"}Spawn Scp-r-p18330

Server online Help2:net use: is a network command inside windows.Function: Connect or disconnect a computer from a shared resource, or display information about a computer connection.This command also controls persistent network connections.3: Backing Up the databaseBackup database A to disk= ' \\192.168.12.30\sqlbak\a.bak 'Backup database A to disk= ' \\192.168.12.30\sqlbak\a1.bak ' with differential (dif

, in the linked server bar, fill in the Ip\ instance name of the standby server, which is the server you want to link to.Note: Here you want to link the standby server, which must be accessible on the primary server. If the standby server is the default instance when you install SQL Server, when you fill out the linked server, you can fill in the IP directly, without adding the instance name, if the SQL Server is a named instance when you installed it, you need to add the instance name. There is

then lock the master database, so that the data is not written in again, and then back up the data in the master database.Flush tables with read lock; the master database locks the table and prevents data from being written.Show master status; view the status of the master database and record the value of FILE and Position.Mysqldump-u root-p db | gzip>/root/sqlbak/db. SQL .gz back up SQL data in the primary database.Slave stop; stop slave from the da