Administrative and Maintenance Tools - vBulletin Cron Based Database Backup

As of 23 Nov 2017 this modification has been withdrawn.

This is a cut down version based on a backup system written by Trigunflame for vb 3.0. It is a simple vBulletin cron trigged php system that does a dump of your database - either as one complete file, or as one file per table. Especially useful now that IB removed the old ACP backup option in vBulletin 4. Files can be (G)Zipped to save space.

All the options are located in the ACP in vBulletin Options >> vBulletin Automatic Backup

To install, download and unzip the files, and follow the instructions in the text file.


History:

v4.0.1 : 28-Dec-2009 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.
v4.0.3 : 27-Jun-2010 : Added Gzip option.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.0.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.
v4.2.0.1 : 17-Mar-2013 : Removed vboptions from backup call..
v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added mysqldump backup.

[chikuru]

what could be the cause of the blank page?
i tried changing the var to mysql also.
is there any way to log the error?

[ozzy47]

Check your server error logs. If you don't know where they are, ask your host.

[john7911]

Hi,
When I download an sql my forum does not work

what is the problem?
Thank you

[john7911]

any solution?

[tbworld]

You would have to leave us more details on what you did. How did you restore the database? What was the reason you had to restore your database from a backup?

[john7911]

Advisor

Join Date: Oct 2008
Posts: 2,133
Design: Red Rum,Wide
You would have to leave us more details on what you did. How did you restore the database? What was the reason you had to restore your database from a backup?

Reply With Quote

I did a back up of my forum , before manipulating into the template, but i was not happy with the modification, and decided to restore the forum.
I have tried directly via phpmyadmin but it does not work properly , then I have used bigdump to do it.
All the table are in the database.



Thank you

[RichieBoy67]

Well this backs up only the database, not the files.

What do you mean it did not work? Do you have ssh access?

[ZeroDoom]

Hi, I'm still confused about the date format and directory of the backups.. Could anyone help? I want mine to backup daily and have the backups stored in public_html/backups

Thanks!

[Mariner1]

Hi. This has been working fine until a few days ago.When trying to do backups now i get this error in admincp

Database error in vBulletin 4.2.2:

Invalid SQL:
OPTIMIZE TABLE `filedata`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, January 2nd 2015 @ 05:54:35 AM
Error Date : Friday, January 2nd 2015 @ 05:55:08 AM
Script : http://www.xxxxxxxxxxx.com/admincp/c...cron&cronid=95
Referrer : http://www.xxxxxxxxxxxx.com/admincp/....php?do=modify
IP Address : xx.x.xxx.xx
Username : xxxxxxx
Classname : vB_Database
MySQL Version :

Any idea what this is and how to fix it pls

[charlesr]

Seems pretty straightforward - the database server was down when you tried to backup. Restart it.
On my linux server this is something like /etc/rc.d/init.d/mysqld restart.
Check logs to see if there's any clue why it was down. Maybe your server overloaded? If so, upgrade to one with more RAM or better IO. VB4 really needs 2GB RAM for a largish forum.