MySQL – backup/dump prefixed tables only

You’ll need this if you only have access to a single database, with many tables from many apps in it -_-

mysqldump -u USER -p DATABASE $(mysql -u USER -p -D DATABASE -Bse "show tables like 'PREFIX%'") > /target/file.sql

http://stackoverflow.com/questions/2949330/mysqldump-more-than-one-table

Leave a Reply

Your email address will not be published.