Wednesday, January 15, 2020

Windows XAMMP Mysql backup with date

Windows XAMMP Mysql backup with the date for 2020


cd\
C:
cd DailyBackups
set TIMESTAMP=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%%
mysqldump -hlocalhost -uroot -pmypassword database1 > ffdel.%TIMESTAMP%.sql
mysqldump -hlocalhost -uroot -pmypassword database2 > ffdel.%TIMESTAMP%.sql

Don't use below Code
set TIMESTAMP=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%%

No comments:

Post a Comment