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]