<div>
Hi ntrsboy,<br />
<br />
Create the following script, and add it to your crontab:<br />
<br />
#!/bin/bash<br />
mysqldump db_name | gzip -c &gt;&nbsp;/var/lib/mysql/backup/$(da<wbr />te +%y%m%d)<br />
<br />
<br />
Cheers!
</div>


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!

<div>
<div class="content wysiwyg-content">
I have a database called 'database1' in/var/lib/mysq/database1.<wbr /> 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 .<br />
<br />
Thanks.<br />

</div>
</div>


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.


How to create dateandtimestamped and gziped backup script

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.