We are downgrading our version of MariaDB, and are looking to take a full backup of all of the databases. I do not want to include system tables since they would be incompatible between the two versions. What would be the best way to accomplish this? After reading through http://mysqlserverteam.com/creating-and-restoring-database-backups-with-mysqldump-and-mysql-enterprise-backup-part-1-of-2/, it seems like everyone is saying that you have to manually exclude them, however I don't want to manually have to type in all of the system databases. What is the best way to accomplish this? Currently I have the following options - `MYSQLDUMP_OPTIONS="--routines --triggers --single-transaction --gtid --master-data --dump-slave --add-drop-database"` This is the current method I have tried - SQL="SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN" SQL="${SQL} ('mysql','information_schema','performance_schema')" echo $SQL DBLISTFILE=/tmp/DatabasesToDump.txt mysql ${MYSQL_CONN} -ANe"${SQL}" > ${DBLISTFILE} Dblistfile includes all of my database names that I want to backup. Is there a better way to do this?