Script
Commands
$ mysqldump -u root -p --all-databases > alldb.sql
Look up the documentation for mysqldump. You may want to use some of the options mentioned in comments:
$ mysqldump -u root -p --opt --all-databases > alldb.sql
$ mysqldump -u root -p --all-databases --skip-lock-tables > alldb.sql
Import:
$ mysql -u root -p < alldb.sql
Latest posts by Rajesh Kumar (see all)
- icinga: How to add new remote server check in icinga2with SSH Protocol - May 7, 2024
- Icinga: How to Install Icinga 2 on Ubuntu - May 7, 2024
- icinga2: How to remove icinga2-ido-mysql configure file - May 7, 2024