Dumping MySQL Tables via a Wildcard
I have been trying to figure out a way to do this for years! I’ve had customers ask to dump tables from a database that match a certain prefix, however mysqldump doesn’t understand how to use wildcards. I used to have to list each and every table by hand in order to create a dumpfile that matched the customer’s requirements. No longer!
The following example can be used to dump all tables that begin with “javier_” from the database called “bigdatabase“:
[Read More]