chicks · April 17, 2014 17:28
diff --git a/mysqldump_tables.sh b/mysqldump_tables.sh
 for t in $(mysql -NBA -D <database_name> -e 'show tables') 
 do 
    echo "DUMPING TABLE: $t"
    mysqldump <database_name> $t | gzip > <some_dir>/$t.sql.gz
 done
	for t in $(mysql -NBA -D <database_name> -e 'show tables')
	do
	echo "DUMPING TABLE: $t"
	mysqldump <database_name> $t \| gzip > <some_dir>/$t.sql.gz
	done