[PHP] Re: PHP Automatic Backup

[Richard Lynch]

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

RE: [PHP] Re: PHP Automatic Backup

[César Aracena]

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:[EMAIL PROTECTED]]
 Sent: Saturday, July 06, 2002 2:06 AM
 To: [EMAIL PROTECTED]
 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


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php