Hello there, I am trying to get auto backups working on my server using this batch file:
@echo off
set hr=%time:~0,2%
if "%hr:~0,1%" equ " " set hr=0%hr:~1,1%
SET backupTime=%date:~-4,4%-%date:~-10,2%-%date:~-7,2%_%hr%-%time:~3,2%
REM echo %backupTime%
cd "C:\xampp\mysql\bin"
mysqldump.exe --user=Epoch_User --password=cheese123 --compact --replace --skip-lock-tables Epoch_Database instance_deployable instance_vehicle profile survivor > "C:\mysqlbackup\%backupTime%.sql"
REM pause
It creates an sql file, but its empty and the window that pops up when I double click it only flashes up so I cant read what it says!
Question
robbiedarza
Hello there, I am trying to get auto backups working on my server using this batch file:
It creates an sql file, but its empty and the window that pops up when I double click it only flashes up so I cant read what it says!
Anyone got any ideas plz?
Cheers
Robbie
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now