O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »
Answered by todisht : Jan 19 2010 06:45 PM
I figured it out:
mysqldump -u [your_username] -p[your_password] [your_database] | gzip > [your_path/filename].gz
If you want to make the filename unique you can add the date to it like this:
my... full answer >
You want to schedule some backups or file transfers via SSH, using cron. How do you tell cron to look to keychain to handle authentication of remote hosts? Use the same source line in your cron s...
It's easy as pie, thanks to cron. Add this line to /etc/crontab to automatically shut down your machine every night at 11p.m.:# m h dom mon dow user command
00 23 ...