windows batch script

PostgreSQL registration Start and Stop unmount batch processing script, postgresql Batch Processing Register to start pg_install.bat: echo offset PGSQL_DIR=%~dp0if not "%PGSQL_HOME%"=="" ( if not "%PGSQL_HOME%"=="%PGSQL_DIR%" ( echo PGSQL_HOME=%PGSQL_HOME% != PGSQL_DIR=%PGSQL_DIR% goto pg_ends )) else ( set PGSQL_HOME=%PGSQL_DIR% echo PG

MYSQL registration Start and Stop unmount batch processing script (Supplement), mysql Batch Processing The batch file that was written earlier when the mysql interface was debugged. Register and start my_install.bat @echo offset MYSQL_DIR=%~dp0rem set MYSQL_DIR=%cd%if not "%MYSQL_HOME%"=="" ( if not "%MYSQL_HOME%"==

MySQL batch insert data script, mysql insert script MySQL batch insert data script #! /Bin/bashi = 1; MAX_INSERT_ROW_COUNT = $1; while [$ I-le $ MAX_INSERT_ROW_COUNT] do mysql-uroot-proot dbname-e "insert into tablename (name, age, createTime) values ('Hello $ I ', $ I % 9

Batch configure SSH mutual trust script and ssh mutual trust script During large-scale automated deployment, we often need to configure SSH mutual trust on the server so that the automated script can log on to the remote server without password. The general steps to manually configure SSH mutual trust are as follows:

1. Batch processing with the parameter ping command@echo offecho Input you IP address ...set/p ip=echo Your IP number is%ip%.Ping%ip%Set ip=Pause2. Send Alarm ScriptFor counter = 1 to 3 Step 1SendMailNext Public Sub SendMail NameSpace = "http://schemas.microsoft.com/cdo/configuration/" Set Email = CreateObject (" Cdos. Message ") Email.from =" Server "' sender name email.to =" [emailprotected] "' Recipient e-mail address Email.subject = GetIP "T

While ;(create a 20 file )Cd/etc/servicesMkdir-p scriptsVim scirpts. Sh#!/bin/bashI= 1, dir=/scirptsWhile [$i-lt 21]Do Touch dir/test$iLet i = $i +1DoneBatch renaming:#!/bin/bashI= 1, dir=/scirptsWhile [$i-lt 21]Do MV dir/test $i alex$iLet i = $i +1DoneDelete inquiry:For file in dir/*Do rm-i $fileDoneThe first thing to do is create an environment#!/bin/bashShopt-s Expand _aliasesAliases=ll= ' Ll-s 'Cd/root/scripts/test/alexif [!-e Alex]Then/bin/mkdir-p AlexElseecho "'"FiPath=/root/scripts/test/a

("--"); Bw.newline (); temp ="drop table"+temp01+"\ngo\n"; Bw.write (temp); Bw.newline (); Bw.write ("--"); Bw.newline (); temp ="CREATE VIEW"+temp01+"As SELECT * from Sys_log_1\ngo"; Bw.write (temp); Bw.newline (); Bw.write ("--"); Bw.newline (); temp ="SELECT * FROM"+temp01+"\ngo"; Bw.write (temp); Bw.newline (); Bw.write ("--"); Bw.newline (); temp ="DROP VIEW"+temp01+"\ngo\n"; Bw.write (temp); Bw.newline (); Bw.write ("--"); Bw.newline (); temp ="CREATE DATABASE"+temp01+"\ngo"; Bw.write (te

The scope of the script in this article applies:1) Detect whether some IP address is occupied;2) detect the existence of some devices in the network;3) batch detect if there are conflicting machines in the environment before assigning a new IP addressThe above detection is based on the ICMP ping message, all devices are required to allow Ping, the device is disabled ICMP policy, firewall prohibit ICMP packe

Goto Begin In this example, all the files on the disk in drive A are copied to D:\back. The comment that appears prompts you to put another disk in drive A, and the pause command suspends the program so that you can replace the disk and press any key to continue processing. 　　Call command 　　Another batch program is called from one batch program, and the parent batch