How to create dateandtimestamped and gziped backup script

I have a database called 'database1' in/var/lib/mysq/database1. A want to backup that database every day via cron. Basicly I need a script who will backup my database every day and I would like the file created from the backup to be dateandtimestamped and gziped which means to have a backup files with time stamp such ymd. For examle let say if today is 17/07/2006 is i need the file to be called something like something like db_060717.gz .

Thanks.
ntrsboyAsked:
Who is Participating?
 
smidgie82Connect With a Mentor Commented:
Oops, should probably tack a .gz on the end of that filename:

mysqldump db_name | gzip -c > /var/lib/mysql/backup/$(date +%y%m%d).gz
0
 
smidgie82Commented:
Hi ntrsboy,

Create the following script, and add it to your crontab:

#!/bin/bash
mysqldump db_name | gzip -c > /var/lib/mysql/backup/$(date +%y%m%d)


Cheers!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.