Administrative and Maintenance Tools - vB Database Backup (Lite)

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it, first for vb 3.6, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later in 2007 David gave me permission to release my adaptation.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (Lite) version that does a php based dump of your database either as one file, or one file per table.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[Phaedrus]

Can you think of a reason why it would just stop in the middle of the "post" table every time I run it from the cron, even a cron directly from my site's server, but if I use mysqlbackup and do it using the php directly, it will take a full backup?

[shofolofo]

Thanks paul, I want to ask some .. euhm .. noobish questions


in the configuration file -- I've made file in path site/vb/backups/
backups file is writable and this is the configuration part

// File Saving Information
$backup['DATE'] = 'Y-M-d'; // Backup file date format (See http://uk.php.net/date)
$backup['PREFIX'] = 'Forum-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = 'backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.


I couldn't modify the date because I didn't understand how to write the scheme from php.net , can you give an example please ?


went to cron jobs and pressed " run now "
An error occured during the Backup : Could not open Destination SQL file for writing.




Thanks for you great mods

[Paul M]

Originally Posted by Phaedrus

Can you think of a reason why it would just stop in the middle of the "post" table every time I run it from the cron, even a cron directly from my site's server, but if I use mysqlbackup and do it using the php directly, it will take a full backup?

Maybe your php installation has a timeout ?

[Paul M]

This is not likely to work ;

$backup['DUMP_PATH'] = 'backups/';

Where exactly is your backups folder (in relation to other folders).

[KEKforce]

Originally Posted by shofolofo

$backup['DUMP_PATH'] = 'backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.

I did $backup['DUMP_PATH'] = './backups/';

Works for me.

[Adem GEN?]

Full path
$backup['DUMP_PATH'] = '/usr/local/******/backups/';

Works for me

[Freddy.k]

Thank you.

[Trek]

Works great, thanks much!

[shofolofo]

Originally Posted by Paul M

This is not likely to work ;

$backup['DUMP_PATH'] = 'backups/';

Where exactly is your backups folder (in relation to other folders).

Originally Posted by KEKforce

I did $backup['DUMP_PATH'] = './backups/';

Works for me.

Thanks Paul, kekforce ... I did it like ./backups/ and it worked



---------------

Is there is a command to add to tar/gz the file then delete it the SQL one ?
the backup is taking about 500 mega ...


tyvm

[Phaedrus]

Originally Posted by Paul M

Maybe your php installation has a timeout ?

Well, it was working for a very long time, then I changed the albums from the database to my files and suddenly when it hits "post" it stops. No other changes were made. Of course, since then I have upgraded to 3.8, but previous to that the 3.7 version ran fine.