Date: Tue, 30 Sep 2008 19:22:33 -0400 From: John Almberg <jalmberg@identry.com> To: freebsd-questions@freebsd.org Subject: Re: Best way to back up mysql database Message-ID: <A2DC4770-11AA-49EF-A4AC-9BA03B27ABC0@identry.com> In-Reply-To: <7F7FCA1B-E46C-4A44-9569-D6638A550FCE@hughes.net> References: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> <7F7FCA1B-E46C-4A44-9569-D6638A550FCE@hughes.net>
next in thread | previous in thread | raw e-mail | index | archive | help
> > DATE=`date +%a` > # > echo $DATE > # > echo Backup Mysql database > mysqldump -h localhost -u YOURSQLUSERID -pYOURPASSWORD YOURDATABASE > >/usr/somedirectory/somefile_$DATE.backup > gzip -f /usr/somedirectory/somefile_$DATE.backup > /usr/bin/at -f /usr/somedirectory/mysqlbackup.sh midnight Ah, a much simpler solution than my ruby script. I hadn't thought to zip up the file before transferring it. That's an improvement I must add. Thanks: John
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?A2DC4770-11AA-49EF-A4AC-9BA03B27ABC0>