Day: August 16, 2022
How to mysqldump All Databases Excluding Information_Schema
If you want to back up your MySQL databases you’ll be familiar with 1 mysqldump -uroot -p --all-databases > dump.sql However this includes the information_schema, mysql and performance_schema databases. These are often not only unwanted in the dump, but can potentially cause issues on import. To exclude these databases from your dump use the…