run pg_dump from docker image

mysql_dump_docker.sh

docker run -it            \
--user $(id -u):$(id -g)  \
-v ~/Desktop:/tmp         \
mysql:5.7.37 /bin/bash -c \
"mysqldump -h hostname -u username -p databasename table1 table2 --port 3306 > /tmp/dumpfile.sql"


# https://stackoverflow.com/questions/44015692/access-denied-you-need-at-least-one-of-the-super-privileges-for-this-operat
grep -n @@SESSION. myDB.sql 
sed -i '18d' myDB.sql

docker run -it            \
--user $(id -u):$(id -g)  \
-v ~/Desktop:/tmp         \
mysql:5.7.37 /bin/bash -c \
"mysql -h mydomain.com -u myUser -p myDb --port 3306 < /tmp/mydump.sql"

pg_dump_docker.sh

docker run -it             \
--user $(id -u):$(id -g)   \
-v ~/Desktop:/tmp          \
postgres:12.8 /bin/bash -c \
"pg_dump -h myhost.com -p 5432 -U myUser -W -v myDb > /tmp/myDb.sql"