ftp batch script

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