NYCPHP Meetup

[Ajai Khattri]

On Wed, 3 Oct 2007, Ben Sgro \(ProjectSkyLine\) wrote:

> I just came into this conversation mid way, but I wanted to include a script 
> I use
> via cron to do mysql backups. Not sure if someone already provided this.
> 
> [sk at tinman ~]$ crontab -l
> 0 */23 * * * /path/to/sql_backup.sh
> 
> [sk at tinman ~]$ cat sql_backup.sh
> DATE=`date '+%m%d%Y'`
> DUMPFILE="/path/to/all_databases-$DATE.sql.gz"
> /usr/bin/mysqldump --all-databases --user=root --password=changeme | gzip > 
> $\
> DUMPFILE


Or avoid re-invention and use automysqlbackup.
http://sourceforge.net/projects/automysqlbackup/



-- 
Aj.