UNLOCK THE SECRET TO AUTOMATICALLY BACK UP AND RESTORE YOUR MySQL DATABASE WITH COMMAND PROMPT

Very good explanation sir

helpful vide.
"D:\MySQL\MySQL Server 5.7\bin\mysqldump" -u root -pbpsc10 --all-databases --single-transaction > "C:\sql\WAGOWKA_%date:~-10,2%-%date:~-7,2%-%date:~-4,4%-%time:~0,2%_%time:~3,2%_%time:~6,2%.sql"

u can also use somethink like this and u will have selfcontatimated file with structure and all data of all your databases

For Restore

cd "C:\Program Files\MySQL\MySQL Server 5.7\bin"

mysql -hlocalhost -uroot -proot worldbackup < "C:\Users\uniqu\OneDrive\Desktop\AutomaticBackup\world_backup.sql"

For Backup use this script

cd "C:\Program Files\MySQL\MySQL Server 5.7\bin"

mysqldump -hlocalhost -uroot -proot world > "C:\Users\uniqu\OneDrive\Desktop\AutomaticBackup\world_backup_%date:~-10,2%-%date:~-7,2%-%date:~-4,4%-%time:~0,2%_%time:~3,2%_%time:~6,2%.sql"