Export each tables of a database in separate files per table¶

#!/bin/bash
GIT_MYSQL=/[BACKUP_LOCATION]
for T in `mysql -u [USER] -p[PASSWORD] -N -B -e 'show tables from [DATABASE]'`;
do
    echo "Backing up $T"
    mysqldump --skip-comments --compact -u [USER] -p[PASSWORD] [DATABASE] $T > $GIT_MYSQL/$T.sql
done;

Source

Import and move processed file¶

for i in *.sql
do
  echo "Importing $i"
  mysql -u admin_privileged_user --password=whatever your_database_here < $i
  mv $i doneFolder/
done