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

mariadb backup #5

Closed
bunkerman opened this issue Oct 25, 2023 · 2 comments
Closed

mariadb backup #5

bunkerman opened this issue Oct 25, 2023 · 2 comments

Comments

@bunkerman
Copy link

Hello,

I just used the script with the Linuxserver mariaDB container and got this error:
" create MYSQL Backup for Database on Container:

  • DB on mariadb
    Usage: mysqldump [OPTIONS] database [tables]
    OR mysqldump [OPTIONS] --databases DB1 [DB2 DB3...]
    OR mysqldump [OPTIONS] --all-databases
    OR mysqldump [OPTIONS] --system=[SYSTEMOPTIONS]]
    For more options, use mysqldump --help"

I added --all-databases to the mysqldump within the script and then it works.

@bunkerman
Copy link
Author

addidtion: I run the script in Open Media Vault. If I run it via CLI it works and if I run in in the OMV GUI I get an "Error "The input device is not a TTY". I changed "docker exec -it" to "docker exec -i" and then it also works in the OMV GUI

@alaub81
Copy link
Owner

alaub81 commented Oct 31, 2023

Hi @bunkerman ,

Thanks for the feedback. On my side the script did not work, too.

I changed the docker execution, the -ti is not necessary.

If you are using more than 1 database in a container, the script is not working. Adding the configuration switch --all-databases is a good way to solve this.

cheers
Andreas

alaub81 added a commit that referenced this issue Oct 31, 2023
related to #5

On branch main
Your branch is up to date with 'origin/main'.

Changes to be committed:
	modified:   backup-docker-mysql.sh
@alaub81 alaub81 closed this as completed Oct 31, 2023
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

2 participants