Backup a remote database to your local filesystem

ssh user@host 'mysqldump dbname | gzip' > /path/to/backups/db-backup-`date +%Y-%m-%d`.sql.gz
I have this on a daily cronjob to backup the commandlinefu.com database from NearlyFreeSpeech.net (awesome hosts by the way) to my local drive. Note that (on my Ubuntu system at least) you need to escape the % signs on the crontab.

17
By: root
2009-02-18 21:12:53

What Others Think

You may want to use / add. -c arcfour
flojo · 613 weeks and 3 days ago
I've been meaning to figure out how to do a mysqldump over ssh for awhile. This is great. I like to use a slightly different pattern for the date, however. I like to add the hours, minutes, seconds and remove some hyphens. ssh user@host 'mysqldump dbname | gzip' > /path/to/backups/db-backup-`date +%Y%m%d-%H%M%S`.sql.gz
wonderwoob · 271 weeks and 2 days ago
https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/   https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/ https://seofox.ir/link-farm-and-content-farm/
seofox · 31 weeks ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands



Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for: