On Sat, 2012-09-08 at 15:53 +1000, Roger wrote:
I got this command line from Google
mysql mydb1 -u user -p password -e 'select tables like
"field_data_field%"'| xargs | mysqldump -u user -p password d7x
I can't see the "select tables" command exists, although "tables"
is a
table with all the tables list. Anyway, you can try something like this:
$ for table in $(mysql mydb1 -Bse 'show tables'); do mysqldump mydb1
$table>$table.sql; done
or using xargs,
$ mysql mydb1 -Bse 'show tables'|xargs -I TAB mysqldump mydb1 TAB -r TAB.sql
which produce both the same result.
Greetings.
--
Rodolfo Alcazar <nospaze(a)gmail.com>