backup and restore of mysql

 #BACKUP

mysqldump  --routines --triggers  --host "hostname" --password --user "mysqladmin@hostname" databasename > /tmp/databasename_dump_27022023

optional:

mysqldump  --column-statistics=0  --routines --triggers  --host "hostname" --password --user "mysqladmin@hostname" databasename > /tmp/databasename_dump_27022023

provide pass

#RESTORE

mysql -u mysqladmin -p  -A -Dnewdatabasename --host newhostname-fqdn < /tmp/databasename_dump_27022023

mysqldump -u... -p... --routines --triggers db1 > /root/db1.sql

login:

mysql  -h hostname.mysql.database.azure.com -u youruser -D yourDB -P 3306 -p -A