Taking a MySQL-dump with a wildcard on table namesMattias Geniar, Thursday, June 13, 2013
Situation: you want to take a mysqldump with all table-names that match a particular pattern, but you don't want all the tables.
root@serv: ~$ mysqldump YOURDBNAME $(mysql -D YOURDBNAME -Bse "SHOW TABLES LIKE 'table_pattern_%'") > /tmp/database-dump.sql
You can modifity the SHOW TABLES LIKE query to include all the table names that you want.
Hi! My name is Mattias Geniar. I'm a Support Manager at Nucleus Hosting in Belgium, a general web geek, public speaker and podcaster. If you're interested in keeping up with me, have a look at my podcast and weekly newsletter below. For more updates, follow me on Twitter as @mattiasgeniar.
In the SysCast podcast I talk about Linux & open source projects, interview sysadmins or developers and discuss web-related technologies. A show by and for geeks!
A weekly newsletter - delivered every Sunday - for Linux sysadmins and open source users. It helps keeps you informed about open source projects, Linux guides & tutorials and the latest news.
Share this post
Did you like this post? Will you help me share it on social media? Thanks!