Return to Answer

Split command over 3 lines; I'd usually want to split the first line further.

edited May 7, 2014 at 23:53

759.5k
145
961
1.3k

This should work onin a shell:

for x in `mysql --skip-column-names -u [username] -p[password] [db name][dbname] -e 'show tables'`;tables;'`; do  mysqldump -u [username] -p[password] [db name] $x > "$x.sql"; sql" done

This should work on a shell:

for x in `mysql -u [username] -p[password] [db name] -e 'show tables'`; do mysqldump -u [username] -p[password] [db name] $x > "$x.sql"; done

This should work in a shell:

for x in `mysql --skip-column-names -u [username] -p[password] [dbname] -e 'show tables;'`; do  mysqldump -u [username] -p[password] [db name] $x > "$x.sql" done

Source Link

answered Feb 20, 2012 at 12:15

Edson Medina

10.3k
4
43
53

This should work on a shell:

for x in `mysql -u [username] -p[password] [db name] -e 'show tables'`; do mysqldump -u [username] -p[password] [db name] $x > "$x.sql"; done

Collectives™ on Stack Overflow

Return to Answer