@rem - file locations for mySQL executables (WAMP Installations) C:\wamp\bin\mysql\mysql5.1.36\bin
@rem - file locations for mySQL executables (XAMPP Installations) C:\xampp\mysql\bin
@rem - Note bene - Time Format is localized in Windows! you may need to twiddle the SET statement!
@rem - point to temp folder for intermediate files workspace.
@rem - before you run this file - create a folder outside your server root for the backup - even better on a different or
remote drive (share)
@rem - now, change to the backup folder
@rem - uncomment this next pause to debug the date & time strings -
@rem - set datetimestamp=%date:~-4%_%date:~7,2%_%date:~0,2%_%time:~0,2%_%time:~3,2%_%time:~6,2%
@rem - these settings are for US date order YYYY_MM_DD
@rem - you are setting (assigning) a variable here to label your backup
echo Please wait, your MySQL backup is in progress...
C:\xampp\mysql\bin\mysqldump --host="localhost" --user="root" --password="" --databases "cdcol" >
if ERRORLEVEL 1 GOTO FAILURE
echo Backup is success
echo There was an error in the backup
Users browsing this forum: No registered users and 86 guests