Tutorials

MySQL :: dump a few tables

:: How to dump a few tables in mysql

mysql databasename -u [root] -p[password] -e 'show tables like "table_name_%"' | grep -v Tables_in | xargs mysqldump [databasename] -u [root] -p[password] > [target_file]

 
:: Link
+ Google
+ StactExchange

Hi, I’m Sysadmin.ID

Leave a Reply

Your email address will not be published. Required fields are marked *