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.

Sign up for GitHub

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

Jump to bottom

Backup all databases instead of the one which is called like the service #109

Open
nik-lampe opened this issue Apr 2, 2019 · 2 comments · May be fixed by #133
Open

Backup all databases instead of the one which is called like the service #109

nik-lampe opened this issue Apr 2, 2019 · 2 comments · May be fixed by #133

Comments

@nik-lampe
Copy link

I'm having the problem that the service which uses my mysql service uses the root user and creates new databases on demand.

When I schedule an automatic backup of the mysql service (or just run mysql:export, comes down to the same command) this only exports the database which is called like the service.

But I want to backup all my databases, or specify which databases I want to backup.

I think it would be easier to backup everything by changing the mysqldump command to use the root user and the --all-databases flag here:

dokku-mysql/functions

Line 97 in 686f692

docker exec "$SERVICE_NAME" mysqldump --defaults-extra-file=/root/credentials.cnf --user=mysql "$SERVICE"

@josegonzalez
Copy link
Member

Pull requests welcome!

@nik-lampe
Copy link
Author

nik-lampe commented Apr 5, 2019 via email

@nubpro nubpro linked a pull request Sep 13, 2021 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat: backup all db nubpro/dokku-mysql
2 participants
@josegonzalez @nik-lampe