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.

[slowphantom]

Thanks Paul for answering
i change it on my php.ini to 120 sec and i got
Database error

Invalid SQL:
SHOW CREATE TABLE `postlog

but on the v3.8.001 : First version for vB 3.8. i never had error
and the execution time was 30 sec too

[Paul M]

Please post the full sql error message.

[slowphantom]

hello paul
here is it

Database error in vBulletin 3.8.4:

Invalid SQL:
SHOW CREATE TABLE `postlog`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, February 7th 2010 @ 07:35:55 AM
Error Date : Sunday, February 7th 2010 @ 07:38:55 AM
Script : http://www.mawane.com/vb/XxxX/cronad...cron&cronid=82
Referrer : http://www.mawane.com/vb/XxxX/index....3Fdo%3Dproduct
IP Address : XxxX
Username : XxxX
Classname : vB_Database
MySQL Version :

Thank You

[slowphantom]

Thank you paul
its working now

after i change the search option to full text search

so it seem that it cant backup when the the forum use the database serach option

[Paul M]

That error means your mysql connection timed out - you probably have a very low timeout value.

[slowphantom]

heu paul
Thank you again
do u mean
mysql.connect_timeout ?
cz i have it -1 means no limit

[Paul M]

No, mysql wait_timeout.

[slowphantom]

oh i dont think this is in php.ini
i think its the host thing

Thanks for replaying paul

have a nice day

[SilabGarza]

how do i make it so only i can access my backup?

[Paul M]

Store them in a place only you can access.