cron and database backup

[dreamer81]

Can i somehow create a cron job that will automatically backup my entire database to a directory on the website???

[msimonds]

i have a script that can do this for you!!!

contact me via PM, email, or IM

[msimonds]

actually here it is via download

http://www.phpfreaks.com/script/view/11.php

[Jose Amaral Rego]

actually here it is via download

http://www.phpfreaks.com/script/view/11.php

Is that for windows or apple? .tar
and how good of a job of a backup it does.

[dreamer81]

that's very neat...
when i upload it to my webserver in the includes/cron dir, how do i assure that noone runs the script????

[dreamer81]

actually here it is via download

http://www.phpfreaks.com/script/view/11.php

argh damn, the script doesn't work in safemode

[dreamer81]

isn't it possible to call the backup.php file in a way so that it will backup???

like in the cron manager type in

./admincp/backup.php?do=choose&something=morething

?????

[feldon23]

http://www.vbulletin.com/forum/showt...694#post898290

[dreamer81]

http://www.vbulletin.com/forum/showt...694#post898290

sorry ur script wont work cause i dont have shell acess to the server.

Could u transfer it to php code????

[dreamer81]

isn't it possible to call the backup.php file in a way so that it will backup???

like in the cron manager type in

./admincp/backup.php?do=choose&something=morething

?????

im quoting myself here, isn't that possible to add the above url in the cron manager?

[feldon23]

You're not understanding the limitations of PHP.

PHP, as set up on most servers, simply stops executing after 30 seconds or less. That is not enough time to perform a full backup of the busier web forums. Also, you would have to create a directory in your forums that is 'world writeable' (0777).

I'm still hopeful that some day, vB might consider writing an advanced backup tool which backs up the tables in groups to separate SQL files and tests each file to see if it matches the estimated file size. Maybe I should write something like this.

[dreamer81]

I'm still hopeful that some day, vB might consider writing an advanced backup tool which backs up the tables in groups to separate SQL files and tests each file to see if it matches the estimated file size. Maybe I should write something like this.

that would be great!

well... i'll figure something out.