Community Add-Ons

I had to use this PHP.ini to fix this error:
PHP Warning: passthru() has been disabled for security reasons in /home/noname/public_html/catalog/mysqlcron.php on line 15

Instructions are commented in the php.ini

1. I Changed code so that database settings are read from catalog/includes/configure.php,
This saves you having to change the code yourself.

2. I added require('includes/configure.php'); to the file so that the mail settings are read
from the store Configuration Settings

3. re-named the file from cron.php to mysqlcron.php


Instructions

1. Upload the files

2. change file permisions on backup folder to 777

3. Consult your serverinstructions on how to setup a cron file

To run the backup manually goto www.domain.com/catalog/mysqlcron.php

Small modifications to original file:
-moved one line of code so that the datestamp works
-changed one line of code so database dumps are stored on server by default

Added instructions in readme file.


This is the whole package!

Works well with snapshot 2.2 of oscommerce.

FUNCTION:

This script makes a backup your oscommerce database and emails it to your email address

automatically.

INSTALLATION:

1.) Configure the first 7 php values at the start of backup/cron.php
2.) Upload the backup dir to your website
3.) Chmod the backup dir to 777
4.) Setup the cron command
If you have cpanel the correct cron command is: php -q /home/username/public_html/backup/cron.php
(username is your cpanel login name)

SUPPORT:
http://forums.oscommerce.com/index.php?showtopic=145603