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. > > [EMAIL PROTECTED] ~]$ crontab -l > 0 */23 * * * /path/to/sql_backup.sh > > [EMAIL PROTECTED] ~]$ 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. _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
