How to dump mysql db from Azure Mysql

First thing need to do is adding your public ip to allow list in Azure DB settings.

Then run a single command, well, you need docker first

docker run -it --rm mysql mysqldump -hsomemysqlname.database.azure.com -usomedbusername -psome-password some-db-name> file.sql

This warning line generated in the top of file should be manually removed.

mysqldump: [Warning] Using a password on the command line interface can be insecure.

--

Feng