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.

[SilabGarza]

for example?

like right now i have the folder set to 777, which means anyone can access it........ >.> that doesn't seem safe to me
how do i make it so only some1 with the password can access it? (or shuld i just make it into a random directory like....

public_html/alkjal3oo3dDDDie3/backups/
?

[Paul M]

No, you use a directory outside of public_html.

[SilabGarza]

how would i do that?

right now i have it set to this
./backups/

hmmm?

[SilabGarza]

still waiting? would the directory be something like....

home/silabgar(my host name)/backups
???

[Paul M]

I cannot generally answer server specific questions. Normally you would create a backups folder in the same location that your public_html is located, and reference it by ../../backups (which is the default setting).

[SilabGarza]

No, you use a directory outside of public_html.

u said that, how would i do that

[Blue91]

Paul,

I installed this. I have a backups folder in the same level as my public folder (in which my forums reside). It has correct write permissions.

I tried running this and get :

An error occured during the Backup :

It has no actual error message and I made no changes to anything in your files.

Can you provide any help?

*edit* - fixed per post 318.

Regards,

[melbo]

From a restore standpoint, is it better to backup with your default separate tables or lump them into one? I've only restored with a xxxxx.sql.gz previously and was wondering what was the better way when using your method? I do have to untick 'extended inserts' when backing up manually and restoring via 'bigdump'.

Does this backup include extended inserts?

[Paul M]

No, this does not use extended inserts.

Personally I prefer to backup one file per table, so that if I need to restore one table I can do it easily.

If I need to restore them all then its easy enough to combine them all into one file first.

[melbo]

Excellent. Thanks a lot