Dump User Databases
By Arch Brooks on January 18, 2026 in Programming
# Get list of non-system databases and dump them
mysql -u root -p -N -e "SHOW DATABASES;" | \
grep -Ev '(information_schema|performance_schema|mysql|sys)' | \
xargs mysqldump -u bcs -p --databases > user_databases_only.sql
Notice none of the system / mysql tables are included.
Views: 24 | Permalink: https://bcs.archman.us/blog.php?slug=dump-user-databases