RE: [PHP] Automated tasks with PHP
| From: | o dot cook at etoncollege dot org dot uk | Date: | Fri, 17 Nov 2000 18:42:58 +0000 |
| Subject: | RE: [PHP] Automated tasks with PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-25945@lists.php.net to get a copy of this message | ||
Or considering it's MySQL you could just get the PHP script to:
tar -c /usr/local/var >> backup.tar
gzip backup.tar
and mail the backup to yourself; where /usr/local/var is where you MySQL
databases are stored.
Ollie
> -----Original Message-----
> From: Kurth Bemis [mailto:kurth@usaexpress.net]
> Sent: 17 November 2000 18:43
> To: rodrigo@shreve.net; php php
> Subject: Re: [PHP] Automated tasks with PHP
>
>
> At 01:31 PM 11/17/2000 -0800, rodrigo wrote:
>
> sure anything's possible with linux :-)
>
> make the script dump mysql tables to files
> then in cron.daily
> write a short bash script to execute the script then tar the
> files and
> finally mail them to root
> make it executable (chmod +x <filename>)
> add the entry to your /etc/crontab file (it tells you syntax
> in the file)
>
> and your done!
>
> ~kurth
>
> >I would like to, say, run a backup script done in PHP (of
> course) that
> >executes itself periodically. For example, every night at midnight I
> >would like it to run itself and make a backup of the entire
> database and
> >mail the compressed files to a certain email adddress.
> >
> >Is this possible?
> >--
> >************************************
> >Ivan R. Quintero E.* (507)228-3477
> >Apto 1263 * (507)228-9105
> >Balboa, Ancon *
> >Republic of Panama *
> >************************************
> >
> >--
> >PHP General Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> >For additional commands, e-mail: php-general-help@lists.php.net
> >To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>
> Kurth Bemis - Network/Systems Administrator,
> USAExpress.net/Ozone Computer
>
> There is no sin except stupidity. -- Oscar Wilde
>
> kurth@usaexpress.net | http://www.usaexpress.net/kurth
> PGP key available - http://www.usaexpress.net/kurth/pgp
>
> Fight Weak Encryption! Donate your wasted CPU cycles to
> Distributed.net
> (http://www.distributed.net)
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>