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@xxxxxxxxx> -- users mailing list users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
