commandlinefu.com is the place to record those command-line gems that you return to again and again.
You can sign-in using OpenID credentials, or register a traditional username and password.
Subscribe to the feed for:
Required : information_schema
** Only replace the "DB-NAME" and "PREFIX" with your DB-name and wildcard prefix match.
** Also replace with your own username and password for mysql server.
This command uses the information_schema to wildcard match tables that we donot need from a database and than pipes the remaining tables out through "xargs" command to the mysqldump utility which than dumps those remaining tables into a sql dump file.
There are 3 alternatives - vote for the best!
Replace DB-NAME and PREFIX with your settings. MySQL username and password handled by ~/.my.cnf.
If you can do better, submit your command here.
You must be signed in to comment.