RE: [PHP] Re: PHP Automatic Backup

Well, thanks for all the ideas. I will try to "communicate" with my host, but I'm sure they will go like "...is not possible unless Cobalt authorizes...". I also like the idea of making a hidden script that visitors will activate... C. > -----Original Message----- > From: Richard Lynch [mailto:rich@phpbootcamp.com] > Sent: Saturday, July 06, 2002 2:06 AM > To: php-general@lists.php.net > Subject: [PHP] Re: PHP Automatic Backup > > >I was reading the post by Pag called “MySQL backups” and I have the same > >question, but not the shell access. It came to my mind, that if will be > >very useful for me, and probably for many of us newbie’s, to be able to > >build an automated PHP system that could make backups by itself at a > >specified time… let’s say maybe every morning at 6 am, by transferring > >or uploading the MySQL files to another server. I noticed that this > >could be done in PHPNuke, by clicking at “Backup Files”. ¿Is it possible > >to build this kind of unattended scripts with PHP or will it always > >require a magical “click” from the administrator? > > > >I guess that it shouldn’t be possible, but it’s worth a shot. > > It *MIGHT* be possible for you to do: > > <?php > exec("/full/path/to/mysqldump -u USERNAME --password=PASSWORD DBNAME", > $output, $error); > echo implode('', $output); > if ($error){ > echo "OS Error: $error. Check 'man errno', but it's almost always > path/permissions."; > } > ?> > > If not, and if you have shell access on *another* machine, you could use > that machine to POST to the other machine a request to push the button. > Totally sucky way to do it, but you could. > > It might be easier to just ask your ISP to create a cron job for you that > dumps the database to a file you can FTP regularly. It would take them > about 5 minutes to do this. > > If all else fails: Just find another ISP that allows SSH access and > switch > hosts :-) > > -- > Like Music? http://l-i-e.com/artists.htm > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php