Adsense
Popular Posts
- MySQL workbench -"Could not decrypt password cache"
- peer review (3)
- PHP, dump varailbes in a format way
- "Unusual traffic from your computer network" from blogger
- Install APXS in Redhat Linux
- JavaScript, remove trailing insignificant zeros after toFixed function
- Update member directory
- Set Windows path command line
- JavaScript: add days to current date
- DataTable table order by numeric, not by text
Tuesday, February 4, 2014
search newer file and add scheduler
In database server
C:\sql_dumps\sql_dump_script
create file jiansen_filecheck.bat, which contains:
set datetimef=%date:~-4%%date:~-10,2%%date:~-7,2%
echo %datetimef% >> filecheck_out.txt
forfiles /p C:\uploads\file_repository /s /D +0 /C "cmd /c echo @path" >> filecheck_out.txt
i.e. get the file list created today and send to file filecheck_out.txt
create scheduler
schtasks /create /tn "check new file" /tr C:\sql_dumps\sql_dump_script\jiansen_filecheck.bat /sc daily /st 23:00:00
change C:\sql_dumps\sql_dump_script\jiansen_ftp.bat to add filecheck_out.txt in ftp list
copy ftp_original.txt ftp1.txt
set datetimef=%date:~-4%%date:~-10,2%%date:~-7,2%
echo mput re*%datetimef%*.sql >>ftp1.txt
echo y >>ftp1.txt
echo mput ce*%datetimef%*.sql >>ftp1.txt
echo y >>ftp1.txt
echo bye >> ftp1.txt
ftp -s:ftp1.txt
to
copy ftp_original.txt ftp1.txt
set datetimef=%date:~-4%%date:~-10,2%%date:~-7,2%
echo mput re*%datetimef%*.sql >>ftp1.txt
echo y >>ftp1.txt
echo mput ce*%datetimef%*.sql >>ftp1.txt
echo y >>ftp1.txt
echo put C:\sql_dumps\sql_dump_script\filecheck_out.txt >>ftp1.txt
echo bye >> ftp1.txt
ftp -s:ftp1.txt
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment