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.

[crouzmind]

sir can you assist me about this error .

An error occured during the Backup :

i have vbulletin 3.8 and i did not know how can i edit my config file please tell me where i need to put the full path of the folder where i want to put the backup dump .

thanks in advanced .

[Simon Lloyd]

Originally Posted by crouzmind

sir can you assist me about this error .

An error occured during the Backup :

i have vbulletin 3.8 and i did not know how can i edit my config file please tell me where i need to put the full path of the folder where i want to put the backup dump .

thanks in advanced .

If you read the text that came with the mod and look at the mod settings you will see where Paul M has already set the folder path you simply need to use this (make sure a folder of that name appears in that location as the mod doesn't create one) or change the folder name and location to yours.

[Vcize]

Originally Posted by Simon Lloyd

Having your folder at public level is not a good idea as explained by PaulM in his mod, your folder should be at least one level up, that way there is no need to password protect it or worry about folk accessing your entire database details. PaulM has already provided a path, simply put your backup folder there.

Perhaps that is my problem. I use dreamhost, so there is no public_html folder or anything like that.

When I log into the root of my server, I just see a folder for each of my sites. Inside each of those folders are the sites files.

So, I created my backup folder in the root, so now the root of my server looks like.

site1.com
site2.com
site3.com
site4.com
backups

Is that right?

[Simon Lloyd]

It should be, if you use a file manager, when you click on the folder or check it's properties what does it show?

[Vcize]

Originally Posted by Simon Lloyd

It should be, if you use a file manager, when you click on the folder or check it's properties what does it show?

I'm using filezilla.

Don't see an option for properties. That permissions are 777.

[Fynnon]

i get an errorr:

Database error in vBulletin 3.8.6:

Invalid SQL:

			INSERT INTO cronlog
				(varname, dateline, description, type)
			VALUES
				('cbu_crontask',
				1319406226,
				'An error occured during the Backup : ',
				0);

MySQL Error   : Table 'cronlog' was locked with a READ lock and can't be updated
Error Number  : 1099
Request Date  : Sunday, October 23rd 2011 @ 11:43:46 PM
Error Date    : Sunday, October 23rd 2011 @ 11:43:46 PM
Script        : http://www.xxx.com/admincp/cronadmin.php?do=runcron&cronid=45
Referrer      : http://www.xxx.com/admincp/cronadmin.php?do=modify
IP Address    : xx.xx.xx.xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.77

[Walter Ronny]

there is a version working for 4.2?

Thanks!

[Paul M]

Yes.

Just click on my title (Dr Pepper ..) and it will take you to the modification list in my profile.

[trotskid]

Hi. It would be possible rewrite the backup file to avoid having to delete every day the accumulate files in the database?

Thanks

[valdet]

Paul,
Is there an easy way to clone the mod, so besides taking daily SQL backups, we can also set a cron job so it takes a monthly backup?

I currently have the Date Format field as d which makes backups in date based directories.

However I'd like to know if it's possible to have another cronjob set up so it takes the monthly backups (e.g. on day 1 of each month) and the Date Format would be M

M A short textual representation of a month, three letters Jan through Dec

Thanks for excellent mod.