MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Mysql server 5.7 recovery
Hayden Perham
June 20, 2021 10:24PM
Re: Mysql server 5.7 recovery
Barry Galbraith
June 20, 2021 11:47PM
Re: Mysql server 5.7 recovery
Hayden Perham
June 21, 2021 04:32PM
Re: Mysql server 5.7 recovery
Barry Galbraith
June 21, 2021 06:28PM
Re: Mysql server 5.7 recovery
Hayden Perham
June 21, 2021 08:02PM
Re: Mysql server 5.7 recovery
Barry Galbraith
June 21, 2021 07:47PM
Re: Mysql server 5.7 recovery
Hayden Perham
June 21, 2021 10:24PM
Re: Mysql server 5.7 recovery
Barry Galbraith
June 22, 2021 12:47AM
Re: Mysql server 5.7 recovery
Peter Brawley
June 21, 2021 07:46AM


Sorry, you can't reply to this topic. It has been closed.

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.