mysqldump -u root -p --all-databases

admin

# mysqldump -u root -p --all-databases > all.sql
1 ?, S+ M) s7 A- Q+ v- ?Warning: Using a password on the command line interface can be insecure.
+ G3 D( ~+ s4 L4 m5 }Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events.
3 t0 y' e3 u+ n6 l6 d
& o2 a5 h% E, x( F0 u! T
9 {3 b: y, J' r! R# d- h& W2 ~