windows batch script

Tags: mysql batch processingA batch file that was written earlier when the MySQL interface was debugged.Register to start My_install.bat@echo Offset Mysql_dir=%~dp0rem set mysql_dir=%cd%if not "%mysql_home%" = "" ( If not "%mysql_home%" = = "%mysql_dir%" ( echo mysql_home=%mysql_home% = mysql_dir=%mysql_dir% goto my_ends )) Else ( set Mysql_home=%mysql_ dir% echo Mysql_home must be

Bgffbffjcg_aaa.html-rw-r--r--1rootroot02 Month 1717:40 Bhcfaabcfh_aaa.html-rw-r--r--1rootroot02 Month 1717:40 Cbbiebdafh_aaa.html-rw-r--r--1rootroot02 Month 1717:40 Dgjdcdfbca_aaa.html-rw-r--r--1rootroot02 Month 1717:40 Diadebbhag_aaa.html-rw-r--r--1rootroot02 Month 1717:40 Efejadfdji_aaa.html-rw-r--r--1rootrooT02 Month 1717:40jcajafgejf_aaa.html Script 2:#!/bin/bash#written by [email protected]path=/goodboy[-D $path] cd $pathfor file in ' ls ' do m

Sometimes, when changing the network environment of a computer, you may need to set the IP address of the computer. If you click Network Connection> Properties> ip address every time, it is not too cumbersome. Next I will introduce how to use batch processing to set the IP address of a computer. Sometimes, when changing the network environment of a computer, you may need to set the IP address of the computer. If you click Network Connection> Prop

Script name is zk_run.shPaste the following code into the zk_run.shAdd Execute permissions chmode +x zk_run.shRun the script./zk_run.sh startIf you find that zookeeper is not starting up, try adding the following line at the top of each zookeeper zookeeper-3.4.10/bin/zkenv.sh scriptExport java_home=/opt/jdk1.8.0_92In this scenario, my script will work.If you're n

Role:Copy the SSH public key of the current machine to another machine. In order to realize from the current machine can ssh without password landing to other machinesUsage:1) Write the IP address you want to add to a file. For example, host2) Save the script as an SH file, such as Install_ssh.sh set the operational permissions3) rewrite the password settings in the script. Only a few password are supported

#!/bin/bashFor user in ' Cat/home/opt/userlist.txt 'DoMkdir-p/app/ftp/issue/merdealfiles/$user/dealfilesMkdir-p/app/ftp/issue/merdealfiles/$user/dealfiles/applyareaMkdir-p/app/ftp/issue/merdealfiles/$user/dealfiles/resultareaMkdir-p/app/ftp/issue/merdealfiles/$user/dealfiles/checkfileschmod 770/app/ftp/issue/merdealfiles/$user/dealfiles/applyareaCat/home/opt/uidlist.txt |while Read UIDDoUseradd-u $uid-G develop-d/app/ftp/issue/merdealfiles/$user $user-S/sbin/nologinDoneecho "$user successfully!!

Role:Copy the SSH public key of the current machine to another machine to enable SSH login to other machines from the current machine without password.How to use:1) Write the IP address you want to add to a file, such as host2) Save the script as sh file, such as Install_ssh.sh set executable permissions3) rewrite the password settings in the script, currently only support a fixed number of passwords.4) Exe

1 " *.pid " ` 2 for inch $head _files 3 Do 4 ' {print $} ' | Xargs Kill-95 rm-f $file6 DoneCode as aboveExplain:1. Find all the PID files in the./fmsconf Directory2. Traverse the found file3. Start traversing4. Separate explanations:1. Cat $file: Print out the contents of file files2. awk ' {print $} ': Print the first unit character3. Xargs: Use the previous output as the input for this4. kill-9: Call Linux bottom, Force kill process5. deleting files6. EndReference Links:Shell Utility

The BAT (batch file) batch is a good thing, the computer Stone age of the weapon, today is still not outdated, the work of accumulating some commonly used batch processing command is still very useful, today to share a practical development used.Scene:You need to start multiple Tomcat services under Windows, and you ne

We use the automatic batch processing program to back up the data. It can generate a backup file on a given day and save the data on a daily basis to a corresponding directory, it should be implemented in combination with windows scheduled tasks. Method 1 CodeBackup The Code is as follows: Copy code @ Echo off setlocal ENABLEEXTENSIONS: ---------- Configuration item ----------: Path

parameter parameter specifies the waiting period, cannot specify a date, can only be a 24-hour time, and the same maximum delay time is one day. Therefore, the following statement. WAITFOR time ' 00:00 ' will run any code before the WAITFOR statement until 0 o'clock in the morning to stop execution. After executing the WAITFOR statement, the next code is followed. Conclusion: Because of limited knowledge, plus beginners, this chapter blog is not very good, there is time to revise. and re-write,

MySQL automatic backup batch under Windows2011-05-04 09:16:45| Category: MySQL| Report | Font size Subscription Backup by system timeNote If there are spaces in the MySQL installation path. The. bat file will be copied to the appropriate directory.1. Direct copy by system timenet stop MySQLxcopy Data\*.* d:\bonadb\%date:~0,10%\/y/s/enet start MySQL2. Compress the backup with compression softwarenet stop MySQLC:\progra~1\winrar\winrar a-ag-k-r-s

Wind7 Batch Set IP (script) Description: Fill in your own IP address at the x.x.x.x. Save as a ". bat" file and run as an administrator. The code is as follows: @echo off : Main Cls echo please follow the instructions ... Echo. Echo 1 Sti-hust Echo 2 dian-hust-711 Echo 3 DHCP Echo 4 Exit Echo. set/p choice= Input A number: Echo. If "%choice%" = = "1" goto Ip_sti If "%choice%" = = "2" goto i

This article describes the MySQL regular batch check table repair and optimization table optimize the shell script, for MySQL database maintenance is very useful! As shown below: #!/bin/bash host_name=192.168.0.123 user_name=jincon.com user_pwd=jincon.com database=my_db_ Name need_optmize_table=true tables=$ (mysql-h$host_name-u$user_name-p$user_pwd $database-A-bse "show Tables ") for table_name in $t

>>>>>>>>> Rman_archivelog.bat CD/D D:\app\product\11.2.0\dbhome_1\BINRman Target sys/[email protected] Catalog rman/[email protected] @ ' F:/DELETE.RMN '>>>>>>>>> Execution Script:delete.rmn run{Allocate channel T1 device type disk;Delete noprompt Archivelog until time ' sysdate-1 ';DELETE Force noprompt OBSOLETE;Crosscheck ARCHIVELOG All;DELETE EXPIRED ARCHIVELOG All;Release channel T1;}They has the separate when done.#!/bin/sh. /u01/app/oracle/.profile1${oracle_home}/bin/rman EOFConnect Target

It is often necessary to periodically delete historical data from certain tables, which are often very large, and in order to mitigate the impact on the online environment, they must be deleted in small batches.Previously shared version of SQL Server.Here is the MySQL version:1 delimiter $$2 Drop procedure if existsProc_delete_old_data;3 Create procedureProc_delete_old_data ()4 begin5 Lp:loop6 Delete fromMyTablewhereCreatedtimeDate_sub (Curdate (), Interval1 Month) limit the;7 ifRow_cou

Full-standby batch processing under win Batch processing is used for game servers, rigorously tested and formally used, and is used primarily to fully back up the database, of course. It's just a few backups. , the function of FTP can be invoked on a remote server that remotely transmits the backed-up data, which is not described in detail and does not understand Can be message, can also mail to jzcxfy@o

1. Create a batch file@echo off rem ########################################################### rem # Windows Server 2008 Oracle Database Automatic backup batch script REM ###########################################################Setcurdate=%date:~0,4%%date:~5,2%%date:~8,2%Sethour=%time:~,2%if "%time:~,1%"==" " SetHou

be a windowsexecutable program, such as your pre-commit.exe or pre-commit.bat ". Of course, you can compile a program in some programming languages, but the implementation is too complicated. Because of its own shortcomings, batch processing is not easy to judge non-empty logs without using other tools. Some examples on the Internet use batch processing in combination with third-party programs, provided th

Wget is commonly used under the Linux/unix download HTTP/FTP data, the use is very convenient, in fact Wget is currently compiled, can also be used under Windows. Recently need to download a large number of remote sensing data, using Python to write a batch download program, using Urllib urlretrieve to download, data download can also, but the interface is not good-looking interactive. The data is improved