Hi Guys,
I have been trying to make a simple batch script to create database backups and move then into a folder named by date, and a sub folder by time.
This is what I have so far:
---
@echo off
@echo Backing Up Server1
mysqldump -A -Q -R -c -e --lock-tables=FALSE -uXXXX -pXXXX -hX.X.X.1 > c:\backup\01.sql
@echo Backing Up Server2
mysqldump -A -Q -R -c -e --lock-tables=FALSE -uXXXX -pXXXX -hX.X.X.2 > c:\backup\02.sql
@echo Backing Up Server3
mysqldump -A -Q -R -c -e --lock-tables=FALSE-uXXXX -pXXXX -hX.X.X.3 > c:\backup\03.sql
set folderdate=%date:~7,2%-%date:~4,2%-%date:~10,4%
mkdir c:\backup\%folderdate%
set foldertime=%time:~0,2%-%time:~3,2%
mkdir c:\backup\%folderdate%\%foldertime%
move c:\backup\*.sql c:\backup\%folderdate%\%foldertime%\
---
I have this scheduled to run every 12hours from 8PM. However, while the batch that runs at 8PM is successful, the 8AM files remain unmoved. In fact in the AM, the 'foldertime' folder is created outside the 'folderdate' folder and sites next to the files that have been created but not moved.
And yet, at 8Pm everything works like a charm. Presumably this has to do with using 24hour time, as the folders are names in 24hr, while XP uses AM/PM in the 'modified' column. I do not see any logic that would cause this to happen the way it does, but I hope someone can point me in the right direction.
thanks
=^_^=
Configuration: Windows XP Firefox 3.0.4
Reply to ghostcorps
|
Insertthe following lines in your batch file:
|
Here is a script in.
# Script MySQLBackup.txt
# Get data and time
var str datetime, date, time
set $datetime = gettime()
# Separate date and time
set $date = { chex -p "8]" $datetime }
set $time = { chex -p "8[" $datetime }
# Make folders for date and time
system mkdir ("c:/backup/"+$date)
system mkdir ("c:/backup/"+$date+"/"+$time)
# Create the backups.
echo "Backing Up Server1 "
system "mysqldump -A -Q -R -c -e --lock-tables=FALSE -uXXXX -pXXXX -hX.X.X.1 > c:/backup/"+$date+"/"+$time+"/01.sql "
echo "Backing Up Server2 "
system "mysqldump -A -Q -R -c -e --lock-tables=FALSE -uXXXX -pXXXX -hX.X.X.2 > c:/backup/"+$date+"/"+$time+"/02.sql "
echo "Backing Up Server3 "
system "mysqldump -A -Q -R -c -e --lock-tables=FALSE -uXXXX -pXXXX -hX.X.X.3 > c:/backup/"+$date+"/"+$time+"/03.sql " |
Batch file find file date Copy file with time and date ms-dos Dos date time format batch File sharing logon failure account currently disabled Ftp.exe move files from one directory to another Getting date time in .bat file How to concatenate date time to dos filename How to get task bad back cant move files Move file older then 30 days Move files from xp to vista thru network Ms dos script create file date time R reading files dates times Script to move files unix Show filtered dataview Text file with time Vista remove movie file "can't delete file" What types of movie files facebook Windows xp change file date