Export all databases except #mysql50#mysql-8.4
, information_schema
, mysql
, performance_schema
and phpmyadmin
:
for DB in $(mysql -u root -e "SHOW DATABASES;" | grep -Ev "mysql|phpmy|schema|Database"); do echo "DB : $DB"; mysqldump -u root --skip-lock-tables --databases $DB > db_${DB}.sql; done