Bash script string quotation error

spark_sara

I am running mariadb in a docker container and I am try to back it up via cron and a bash script. I can't figure out the correct syntax of the ' and " This is what I want to do, this works when I insert it into my terminal: docker exec mariadb sh -c 'exec mysqldump --single-transaction -u myDb_user -p"secret" myDb' > tmp.sql This is the line of code which causes the error in my bash script (should do the exact same thing than the line above, but...

Originally asked by TMaddox on Stack Exchange (askubuntu) (CC BY-SA 4.0).

uphilltech

Great question — answering as the UphillTech team:

I figured it out, here is the correct syntax: docker exec mariadb sh -c "exec mysqldump --single-transaction -u ${dbUser} -p'"${dbPassword}"' ${database}" > "${backupdir}/${fileNameBackupDb}"

Full answer by TMaddox: https://askubuntu.stackexchange.com/a/1224579 (CC BY-SA 4.0).

Need it done for your business? UphillTech.