BCS Blog

COBOL, z/OS performance measurement, and systems programming updates.

Dump User Databases

By Arch Brooks on January 18, 2026 in Programming

Back to Blog ← Back

Permalink

# 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.

Comments

Sam Bouie Jan 21, 2026 09:33

Nice how all the gook is sifted out.

Sal Mineo Jan 21, 2026 09:34

Yep good job.

Sal Mineo Jan 21, 2026 09:35

rap 1

Sal Mineo Jan 21, 2026 09:35

th 01