MySQL Forums
Forum List  »  Newbie

Re: Mysql server 5.7 recovery
Posted by: Barry Galbraith
Date: June 22, 2021 12:47AM

Glad you got your database sorted.

Your task now is to establish a backup routine, possibly using Windows Task Scheduler to run a batch file to dump to a file named for the time/date of the backup.
A method is shown here. Customise for your own needs.

https://stackoverflow.com/questions/31787056/windows-batch-script-to-backup-local-mysql-databases-only-keep-n-latest-folder


You might also investigate turning on binary logging if it isn't already on.
Binary logging allows "point in time" recovery. You can restore changes that were made AFTER the backup was taken.
It's in the fine manual.
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Mysql server 5.7 recovery
June 22, 2021 12:47AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.