[vbcron] Automatic database backup [v1.3]

This script will allow you to automaticly back-up your vBulletin database (or any database you have access to).


Current Stable Version: 1.3.1

System Requirements-

vBulletin RC 2 or later
Unix/Linux server with MySQL Dump support
Ability to chmod folders to 777 (775 works on some servers)

[high]IMPORTANT NOTE TO ALL THAT USE THIS SCRIPT[/high]

This script invokes an outside process that runs in the backround on your server to backup and compress your database. It is important to remember that this is not an instant process, do not enter you ftp as soon as the script says it is done and try to download your backup. It will likely be incomplete and your server will probbly still be writting the file to disk.

I ussally give the process an hour or two before I mess with the file, larger databases will take more time of course.

Installing the script-

1. You will need to change the information here for it to work correctly on your server:

PHP Code:

// ######################## Begin edits ######################
define('DB_HOST', 'localhost'); // database host

define('DB_USER', 'db_user'); // database username

define('DB_PASSWORD', 'password'); // database password

define('DB_NAME', 'db_name'); // vbulletins database name

define('DUMP_PATH', '/path/to/dump/folder'); // path to where db backup will be stored

define('DUMP_MAKE_TAR', 1); // set this to 1 for the backup to be compressed in a .tar.gz file
// ####################### End Edits ########################## 


2. CHMOD the folder you specified in DUMP_PATH to 777

3. Upload the vbcron_db_backup_131.php file to the /vbroot/includes/cron directory

4. Enter you admin control panel, under Scheduled Tasks click [high]Add New Scheduled Task[/high]

Enter the information has follows:

Title: Automatic Database Back-up

Day of the Week:

This is the day of the week the task should run on. Set this to * to have it not apply, or for it to run every day (if Day of the Month is set to * below). Otherwise select a specific day. Note that this will override the day of the month option, unless this is set to *.

Day of the Month:
Set this to the specific day of the month the task should run. This is overridden by the Day of the Week setting above. Set this to * to have it not apply.

Hour:
This is the hour of the day the task should run. Set it to * to have it run every hour.

Minute:
This is the minute of the hour the task should run. Set it to * to have it run every minute (not really recommended!).

Log Actions:
If this is set to Yes, every time the scheduled task runs, a log will be made indicating that the task was run, and in certain cases, additional information will be provided (e.g. for the Birthday Email task, the usernames who were sent birthday wishes will be noted).

Filename:
Enter the path to vbcron_db_backup_131.php, ./includes/cron/vbcron_db_backup_131.php should work in most cases

What was added in 1.3.1

- Fixed all bugs reported in 1.3

What was added in 1.3

- Added ability for script to leave logs

Improvments to come:

- Email alert when db is begin backed up
- Close board when back-up is in process
- 'Lock down' db durring backup so no one can access it
- Table, by table back-up
- Clear session table before backup
- Make script more windows friendly
- Delete last .sql (or .tar.gz) file when doing current back-up
- [high]Ability to use hashed file names for back-ups[/high]
- [high]Save back-up to forgin server[/high]

To come: version 2.0

2.0 will introduce most, if not all the fetures listed above.

Public beta testing will begin in the next few days, expect a stable version in at least 2 weeks time.

[Symbian.info]

Originally Posted by Brad.loo

This is a vbcron script that will backup your database to a .sql file on your server.

You need MySQLdump for this to work, also a folder chmoded to 775 (or 777).

You will need to change the information here for it to work correctly on your server:

PHP Code:

// Set these vars up to to suit your server
define('DB_HOST', 'localhost'); // database host
define('DB_USER', 'user'); // database username
define('DB_PASSWORD', 'db_pass'); // database password
define('DB_NAME', 'vbulletin'); // vbulletins database name
define('DUMP_PATH', '/path/to/dump/folder'); // path to where db backup will be stored
define('DUMP_MAKE_TAR', 1); // set this to 1 for the backup to be compressed in a .tar.gz file
// end changes 


Remember to upload this script to /vbroot/includes/cron!!

Does not work for me:-( Get:

MySQL backup

All Done

vBulletin v3.0.0 Release Candidate 3, Copyright ?2000-2004, Jelsoft Enterprises Ltd.


Fatal error: Call to undefined function: query() in /home/mywebiste/www/forum/includes/functions.php on line 501


But no backup is made:-(

[alkahf]

That is the best hack in 2004.

Thank you

[alkahf]

Hello
Yesterday I installed this hack like that :



Today I login to Ftp and I see that :



Tell me please what the problem?

Thank you

[heynurse]

Originally Posted by Symbian.info

Does not work for me:-( Get:

MySQL backup

All Done

vBulletin v3.0.0 Release Candidate 3, Copyright ?2000-2004, Jelsoft Enterprises Ltd.


Fatal error: Call to undefined function: query() in /home/mywebiste/www/forum/includes/functions.php on line 501


But no backup is made:-(

I had this problem too at first, I had a space in my folder name, I removed the space and it worked fine. Not sure that will help you or not, but thought I'd try.

[Natch]

Originally Posted by alkahf

Hello
Yesterday I installed this hack like that :



Today I login to Ftp and I see that :



Tell me please what the problem?

Thank you

No problem - except it seems you have the hack setup to run every minute ...

[alkahf]

Originally Posted by Natch

No problem - except it seems you have the hack setup to run every minute ...

Thank you Natch
But did you notice ( in my images ) that hack does not deleted last backup files?
untill now I deleted laste backup files manualy every day.
Tell me please what's the problem ?

Best regards
alkahf

[Onkel_Tom]

This Hack only makes a backup of the database !
There ist no code for deleting old backups.

If you want to do that you have to add a line like
exec('rm ' .DUMP_PATH. '/yourolddatabasename.tar.gz');

in your cron_dbbackup.php file before backing up the actual db

[Natch]

Or you can cause the hack to overwrite with the latest backup (weekly) by using the day of the week modification, instaed of the unix timestamp filename...

[Onkel_Tom]

arggh !
I configured in the options to log the activity of this backup script, but I no activities are logged !
Script is running fine every day and backing up the db.

anybody an answer or solution ?

[paulomt1]

Don'r work for me. no backups recorded.

:
Database Backup

Done

vBulletin v3.0.0, Copyright ©2000-2004, Jelsoft Enterprises Ltd.

My defs:
// Set these vars up to to suit your server
define('DB_HOST', 'localhost'); // database host
define('DB_USER', 'dbusername'); // database username
define('DB_PASSWORD', 'dbpass'); // database password
define('DB_NAME', 'dbname'); // vbulletins database name
define('DUMP_PATH', '/public_html/foruns/dbBackup'); // path to where db backup will be stored
define('DUMP_MAKE_TAR', 1); // set this to 1 for the backup to be compressed in a .tar.gz file
// end changes

What I made wrong?