Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature] MySQL restore - have a proof of concept version - comments please - PR later. #104

Open
michael-paddle opened this issue Oct 12, 2018 · 1 comment

Comments

@michael-paddle
Copy link

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

@michael-paddle
Copy link
Author

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant