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.

[Paul M]

I have used the backups a number of times, so I have no idea what your issue was (since you dont actually give any clue, I cant even guess).

[onehost]

Originally Posted by Paul M

I have used the backups a number of times, so I have no idea what your issue was (since you dont actually give any clue, I cant even guess).

The only clue that I can give you is when I tried to restore your backup, everything
was disorted, everything was out of place...I tried 3 different backups that
your mod created, same result, I restored my manual backup, everything was fine.

[TeknoSounds]

Originally Posted by onehost

The only clue that I can give you is when I tried to restore your backup, everything
was disorted, everything was out of place...I tried 3 different backups that
your mod created, same result, I restored my manual backup, everything was fine.

this is of pretty big concern, would you provide Paul a copy of your backup to look at to see what the differences are?
Or I could if we don't hear back or onehost doesn't want to...

[CheeSie]

Any idea why this makes my server become unresponsive?
Whenever it runs a loooooot of new mysql process gets created and the same happens with apache..
Is there some way to limit the script to not use all system resources or something.. cause it's really annoying
(But anyway I love the script as it's reaaaaaaaly useful!)

[d-red]

where does it get saved to? what folder?

[Paul M]

Wherever you set it.

[Desibabu19]

Paul,

I have been using this hack for last 6 months.
I have database corruption. I am trying to restore from the backup created yesterday.
I have database connection error. I am not sure how I should fix it.

The only recent backups I have are taken using this hack. All other backups are more than 6 months old. I have a busy forum with more than 30,000 members.

Please suggest a solution ?

[Paul M]

A solution to what exactly ?

What do you mean by "database corruption" ?

Also, I cannot tell you how to fix mysql conection errors on your server, you need to speak to your host. That is a server/mysql issue, not a vbulletin or database problem.

[Desibabu19]

Paul,

For a moment I was wondering if there was a problem with this hack. Sorry about it.

Everything is fine. Couple of tables got corrupted. I don't know how.
So the last backup was not good. Backup taken a day before was good.

Thanks for your hack. Backup created by your hack was good and we used that restore everything.

[dcuellar]

Paul,
I recently received an e-mail from my host telling me that I can not use the database for storing files. The files they pointed out to me were some database backups that had been done a while ago, which is fine because I want to replace them every week. What date format should I use so that every week I have a new set of backups replacing the old ones? Would 'D' work?