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.

[Paul M]

Yes, you must create the folder.

[bleros]

Originally Posted by Paul M

Yes, you must create the folder.

im get this error

Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 211

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 246

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 257

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 153

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 163

or this

An error occured during the Backup : Could not open Destination SQL file for writing.

are sometimes created a folder with the date. has nothing but the error

[Paul M]

open_basedir is a php security feature on your server, you need to talk to your host.

[bleros]

Originally Posted by Paul M

open_basedir is a php security feature on your server, you need to talk to your host.

ah yes SAFE MOD in server is ON .. i.e not work with SAFE MODE ON

[centurius]

Installed and works 90% perfectly. Only issue I have is that it does not re-enable my forum once it's done- and that was easily worked around using the config file.

[smartkidbk5]

i keep getting this error:

PHP Code:

Automatic Database Backup for vBulletin 3.8
An error occured during the Backup : Could not open Destination SQL file for writing. 


what is wrong?

[Outbackmark]

You have not created the folder for it to write to or set the permissions correctly.

[Yonatan]

Originally Posted by smartkidbk5

i keep getting this error:

PHP Code:

Automatic Database Backup for vBulletin 3.8
An error occured during the Backup : Could not open Destination SQL file for writing. 


what is wrong?

Originally Posted by Outbackmark

You have not created the folder for it to write to or set the permissions correctly.

This is unattached.

That error showing because Safe Mod turn on on his server.
turn off it and the problem will be solved

[Outbackmark]

I have this installed on a number of sites, all on the same server, not in safe mode. On one site I forgot to set the folder up properly and that is exactly the same error I got. If something on the server was running in safe mode he would be having all sorts of other issues.
If you look back in this thread the error has been encountered a few times, each time is because the folder that the script writes to is not properly set up. The folder must be in the same folder that has your main vb files in it and be named the same as it is called in the config file and must have the permissions correct.
If the above is not done you will get exactly that error.

If PHP is in safe mode you will get this error -

Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 211

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 246

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 257

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 153

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 163

[ITDarasgah]

after run show me this message tell me this is okay or not...no other message show.

Automatic Database Backup for vBulletin 3.8
Processing access : Total Rows = 10
Processing adminhelp : Total Rows = 1690
Processing administrator : Total Rows = 4
Processing adminlog : Total Rows = 4405
Processing adminmessage : Total Rows = 0
Processing adminutil : Total Rows = 1
Processing album : Total Rows = 1
Processing albumpicture : Total Rows = 2
Processing albumupdate : Total Rows = 1
Processing announcement : Total Rows = 1
Processing announcementread : Total Rows = 17
Processing attachment : Total Rows = 703