Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6

This modification is no longer available or supported.

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 for vb 3.6.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. A while ago David gave me permission to release my adaption, but until now I haven't got round to it. Trigunflame did mention a few months ago he was working on a new version, but nothing ever appeared.

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. It's been in use on our forum since the day 3.6 was installed.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic 3.0 backup functionality on 3.6.


History:

v2.10 : First internal version.
v2.11 : Bug fixes, some code changes.
v2.12 : Initial Public Release.

[Paul M]

Check with your host - I would guess they have restrictions in place to stop you writing to folders outside of your web root (assuming that's what you mean).

[chingon]

Thank you for the reply. I am trying to write it to /admin/backups/ from my root, starting folder. I have been trying to do it by /../../admin/backups but nothing seems to work no matter how many dots or slashes I put.

I'n new at this so sorry If I don't make much sense.

[Sevo]

Ok sorry for the newb question but I have configured the mysqlbackupconfig.php and uploaded the xml file.. how do I adjust the timing of the back ups. I dont see anywhere this product in my Admin CP. How do I make the program run?

again sorry for the lame question, I am just now starting to figure Vb out.

thank you

[chingon]

Look in the admin cp under scheduled tasks and scheduled task manager. It should be called database backup. You can click edit for scheduling or click run now to see if it's working properly.

[KW802]

After two MySQL crashes in one week I was looking for a good backup solution and this does the job very nicely.

Between this hack and using WS_FTP's Synchronize utility I have a fresh backup on my local PC daily now. Eventually I'll do something to remove the old backups on the server but for now the solution is working nicely.


(And, looking the backup size of each individual table, I spotted a few things that I don't think would've normally caught my attention. Things like a 2gb ModeratorLog table! )

[silvermerc]

I thought you might want to know that this version doesnt work with vbulletin 3.7.0 BETA 3

This isnt the only hack that doesnt work but i get this error...

A conflict was detected in the bitfields. You cannot continue with the installation of this product until this has been fixed. The conflicts found were:
Bitfield Collision: credits_cantearn = prefixrequired

[Paul M]

Sorry but that error has nothing to do with this modification.

[taydu]

Paul,

For some reason this mod didn't run properly today. I started run for a while but never finish or end it. I set to close the forum when it back up, but 5 hours after it run the forum still close. So I when to task scheduler and run it manually it run ........ but then it never finish. Usually when it finish i going to say finish, with 0 error now it doesn't say that

[SpArKs85]

Everything was working fine since 16th dec. Until I noticed the forums stayed switched off for an unusual amount of time today. So I turned vB off, then on again to enable the forums. Ran the scheduled task manually and I got the following sql error and the forums got switched off and stayed off...

Database error in vBulletin 3.6.8:

Invalid SQL:

			REPLACE INTO datastore
				(title, data, unserialize)
			VALUES
				('options', 'INSERT LARGE AMOUNT OF DATA', 1);

MySQL Error  : Table 'datastore' was locked with a READ lock and can't be updated
Error Number : 1099
Date         : Sunday, January 6th 2008 @ 05:56:39 AM
Script       : http://www.tricksofthetradeforum.net/admincp/cronadmin.php?do=runcron&cronid=21
Referrer     : http://www.tricksofthetradeforum.net/admincp/cronadmin.php?do=modify
IP Address   : ?????????????
Username     : Tag
Classname    : vb_database

[Paul M]

The error is pretty self explanatory - something (else) has locked the datastore table, preventing it being updated.