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.

[doogie88]

I found about 40gigs of backups for everyday for the last year. Is there any way to delete them automatically after a few days?

[Skyrider]

ERROR 1062 (23000) at line 3555885: Duplicate entry '37560' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555886: Duplicate entry '37561' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555887: Duplicate entry '37562' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555888: Duplicate entry '37563' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555889: Duplicate entry '37564' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555891: Duplicate entry '37565' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555892: Duplicate entry '37566' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555893: Duplicate entry '37567' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555894: Duplicate entry '37568' for key 'PRIMARY'

ERROR at line 3555919: Unknown command '\"'.
ERROR at line 3555919: Unknown command '\"'.
ERROR at line 3555919: Unknown command '\"'.
ERROR at line 3555919: Unknown command '\"'.

When I attempt to 'import' a database through shell.. Used this cron to make a backup. The duplicate entry errors, getting tons of them... And with tons, I mean thousands (and more). Importing it into an empty database. What exactly is wrong?

EDIT:

There's more...

ERROR 1064 (42000) at line 3555895: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '37569','-1','viewing_users_album','wol','Viewing User\'s Album','vbulletin','vBu' at line 1

ERROR 2005 (HY000) at line 3555919: Unknown MySQL server host 'size="2">A' (1)
ERROR at line 3555920: Can't connect to the server

[bzcomputers]

Originally Posted by doogie88

I found about 40gigs of backups for everyday for the last year. Is there any way to delete them automatically after a few days?

Under options:
Combine Files set to: Yes
Date Format enter: D
GZip Files: Yes

This will save your backups like this:
Prefix-Mon-Full-Backup.sql.gz
Prefix-Tue-Full-Backup.sql.gz


....this way you will only have 7 daily backups (one for each day of the week) that will overwrite each other the following week.

[Soapchick]

Paul M, I can't tell you how many times this mod has saved my butt. The backups work perfectly with bigdump. I just wanted to say thank you.

[Pyanepsion]

Hi,

I installed Auto-Backup for Vbulletin 4.2.2 patch level 1 but that doesn't work. When I start instant backup this message error appears :

Backup Error : Could not write to destination file ( ../../backups/wmp-2014-05-28-Full-Backup.sql )

You can see my configuration on there screnshots :
http://img11.hostingpics.net/pics/578120backup.jpg
http://img11.hostingpics.net/pics/391972backup2.jpg

[RichieBoy67]

Originally Posted by Pyanepsion

Hi,

I installed Auto-Backup for Vbulletin 4.2.2 patch level 1 but that doesn't work. When I start instant backup this message error appears :

Backup Error : Could not write to destination file ( ../../backups/wmp-2014-05-28-Full-Backup.sql )

You can see my configuration on there screnshots :
http://img11.hostingpics.net/pics/578120backup.jpg
http://img11.hostingpics.net/pics/391972backup2.jpg

Check your file permissions. Usually that folder has to be set to chmod 777 so it can be written to. Either that or your file path is wrong. And you do not need to put the name of the file in the file path if that is what you did..

Go into Vbulletin under maintanance, phpinfo and get your path there. Yours is wrong.

[Pyanepsion]

The visible path was not good. Thank you very much RitichieBoy67.

[RichieBoy67]

Originally Posted by Pyanepsion

The visible path was not good. Thank you very much RitichieBoy67.

My pleasure.

[tironcitironci]

Warning: Assigning the return value of new by reference is deprecated in ..../includes/cron/cronbackup.php on line 18
Backup Error : Could not write to destination file ( ../backups/2014-05-29/Forum-2014-05-29-Access.sql )

i got this :/

[Paul M]

You need to update to the latest version (4.2.0.2).

v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added experimental mysqldump backup.