List and Export MySQL/mariaDB Databases

snippet.sh

# Login to find your db name (optional)
mysql -u username -p

SHOW DATABASES;
EXIT;

# Export
mysqldump -u username -p dbname | gzip > dump.sql.gz

# Copy it from server to local (optional)
scp -P 22 user@server:/home/user/dump.sql.gz C:\Users\user\Downloads

# Import it into your Docker container (very optional)
zcat < dump.sql.gz | docker compose exec -T mariadb mariadb -uroot -proot db