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:
Backups all MySQL databases to individual files. Can be put into a script that grabs current date so you have per day backups.
There are 3 alternatives - vote for the best!
No need to loop when we have `xargs`. The sed command filters out the first line of `show databases` output, which is always "Database".
just better bash
Backs up all databases, excluding test, mysql, performance_schema, information_schema.
Requires parallel to work, install parallel on Ubuntu by running: sudo aptitude install parallel
If you can do better, submit your command here.
You must be signed in to comment.