Dump all mySQL tables with a certain prefix

#/bin/sh
# -B = run batch command
mysql -u username -ppassword -h db \
      -B --skip-column-names INFORMATION_SCHEMA \
      -e "SELECT TABLE_NAME FROM TABLES WHERE TABLE_NAME LIKE 'pre_%'" \
      | xargs mysqldump -u username -ppassword -h db -B database_name --tables > ~/drupal_db_backup.sql