I am unix man, and I really don't like work on windows. I am asking You for help.
I am trying to make regular backups of mysql database in microsoft windows cmd. Here is my current script for that:
C:\xampp\mysql\mysqldump.exe -hlocalhost -uroot -ppass stp > V:\backup_3.2.2.6__%date:/=%.sql
I would like to file name have structure like that:
backup_3.2.2.6__2015-06-02_10:25:35.sql
where is:
name__currentDate_currentTime.sql
So I just need to add current time to file name.
Please help
Here is working solution:
C:\xampp\mysql\mysqldump.exe -hlocalhost -uroot -ppass stp > V:\backup_3.2.2.6__%date:/=%_%time:~0,2%-%time:~3,2%-%time:~6,2%.sql
Where "pass" is Your password for root user
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments