[thelist] MySQL Backup Statement

[A Maynes]

I'm not too fmailiar with shell which part would I put in the .sh file?

Could you point me to a shell tutorial for this setup please?

Would I need to have gz installed?

Andrew


> -----Original Message-----
> From: Dan McCullough [mailto:dan.mccullough at gmail.com] 
> Sent: 05 August 2005 15:02
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] MySQL Backup Statement
> 
> 
> you could so a simple shell script and cron it.
> 
> 
> #!/bin/sh
> #backup.sh
> 
> date=`date -I`
> rm -f /var/backup/dbname-bak-*.sql.gz
> /opt/mysql/bin/mysqldump --opt --quote-names -u <user> -p<pass> dbname
> | gzip > /var/backup/dbname-bak-$date.sql.gz
> 
> 
> 
> On 8/5/05, A Maynes <andrew at milords.com> wrote:
> > I need to run a simple MySQL Backup statement without 
> causing too much 
> > strain on the server what would be the best method?
> > 
> > I am thinking about running a cron to run a PHP script which simply 
> > dumbs the backup file in a DIR on a daily basis?
> > 
> > Anyone have a pointer to the PHP code please
> > 
> > Andrew
> > 
> > --
> > 
> > * * Please support the community that supports you.  * * 
> > http://evolt.org/help_support_evolt/
> > 
> > For unsubscribe and other options, including the Tip Harvester and 
> > archives of thelist go to: http://lists.evolt.org Workers 
> of the Web, 
> > evolt !
> >
> -- 
> 
> * * Please support the community that supports you.  * * 
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !