Database Reference
In-Depth Information
%
mysqldump --routines --events --all-databases > dump.sql
No database names are given with this command.
mysqldump
asks the server which
databases exist and dumps them all.
To reload the dump file:
%
mysql < dump.sql
An all-databases dump can take a long time to produce and reload. Using several single-
or multiple-database dumps may be a better strategy because you can work with smaller
parts of your installation.