schickling
[Feature] MySQL restore - have a proof of concept version - comments please - PR later.
Hi @schickling ;
Just to say that I have created a restore container for mysql. It's mixed in with another repo where I'm experimenting with mysql cloud backup restore https://github.com/PaddleHQ/rds-dump-restore/tree/master/s3-restore-mysql If you want to grab the script then feel free; Although some parts of that repo are under GPL licensing, I kept those files clearly under MIT. The current version only restores the latest backup which fits my current tests but I will likely later improve that.
If you have any suggestions for improvement or ways to better match your docker files I'll likely try to implement them. Please do comment. Once I have finished experimenting and assuming you are interested I will likely make a PR with my new script + some changes to the mysql backup script. https://github.com/PaddleHQ/rds-dump-restore/tree/master/mysql-backup-s3
Okay, so I have got to the stage that I have fully automated verified backup/restore of mysql and put it up in my repo. I made considerable changes and refactorings to the script to improve their maintainability, portability and coding standards (as defined by shellcheck).
Unless someone wants to cooperate soon I may soon change the functionality and eliminate unencrypted backup or at least make it require an explicit setting so later versions in my repo may no longer be interesting for you.
If asked I can do a PR of just the scripts. Otherwise I'm just going to leave this here and anyone who wants mysql backup and restore can simply find my repo.