bat计划任务(windows)

-------------------------------------------------------------------------------------------------------------
path D:/wamp/bin/mysql/mysql5.0.45/bin

::mysqldump -uroot -psar123 --default-character-set=utf8 --opt pmc > E:/DBback/%date:~0,4%%date:~5,2%%date:~8,2%_pmc.sql

mysqldump -uroot -psar123 --default-character-set=utf8 --opt pmc > E:/DBback/%date:~0,4%%date:~5,2%%date:~8,2%_pmc_myisam.sql


::----winrar.exe the datafile--------------------------------

c:
cd C:/Program Files/WinRAR
::winrar a E:/DBback/%date:~0,4%%date:~5,2%%date:~8,2%_pmc E:/DBback/%date:~0,4%%date:~5,2%%date:~8,2%_pmc.sql

winrar a E:/DBback/%date:~0,4%%date:~5,2%%date:~8,2%_pmc_myisam E:/DBback/%date:~0,4%%date:~5,2%%date:~8,2%_pmc_myisam.sql

::del -f E:/DBback/%date:~0,4%%date:~5,2%%date:~8,2%_pmc.sql

del -f E:/DBback/%date:~0,4%%date:~5,2%%date:~8,2%_pmc_myisam.sql

 

-------------------------------------------------------------------------------------------------------------

::----rar.exe the datafile and ftp to rs3--------------------------------

c:
cd C:/Program Files/winrar
winrar a -afzip -ep F:/data_pmc/offers_us_qa_%date:~5,2%%date:~8,2% F:/data_pmc/offers_us_qa_%date:~5,2%%date:~8,2%.sql

echo the data file is:  F:/data_pmc/offers_us_qa_%date:~5,2%%date:~8,2%.zip
::pause

d:
cd D:/www/bat/sqls
echo open rs3.etiwebhosting.com>ftp_qa.txt
echo pmcuser>>ftp_qa.txt
echo 9kM0ds9P23Eq>>ftp_qa.txt
echo cd /var/www/rs3.etiwebhosting.com/httpdocs/pmc/data>>ftp_qa.txt
echo prompt>>ftp_qa.txt
echo bin>>ftp_qa.txt
echo put F:/data_pmc/offers_us_qa_%date:~5,2%%date:~8,2%.zip>>ftp_qa.txt
echo quit>>ftp_qa.txt

ftp -s:D:/www/bat/sqls/ftp_qa.txt

::pause

 

 

open rs3.etiwebhosting.com
pmcuser
9kM0ds9P23Eq
cd /var/www/rs3.etiwebhosting.com/httpdocs/pmc/data
prompt
bin
put F:/data_pmc/offers_us_qa_0411.zip
quit

 

-------------------------------------------------------------------------------------------------------------