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]

I've had it happen randomly in the past, so I no longer use the option.

[JohnBee]

Walked into my forum today only to find it was closed for backup! I received countless emails that the site was closed all day.

What's more interesting is I had no option to turn it back on lol
Anyways, I uninstalled this hack until it gets fixed.

[Paul M]

Originally Posted by JohnBee

What's more interesting is I had no option to turn it back on lol
Anyways, I uninstalled this hack until it gets fixed.

You turn it on in the ACP.

It's not going to get "fixed" as there is nothing to fix, it's just a blip that sometimes happens. Like database errors.

Uninstalling it is a pointless and extreme route to take, just don't use the option if it bothers you. There is no need to close the forum during a backup.

[melbo]

Strange. I had the same thing happen last night.
Forum was closed all day and I had to go into vb options/ turn your forum on and off and turn it off and then back on to clear it up.

I've used this backup without fail for awhile now and this is the first problem I've had.
Odd that it happened to another forum as well at the same time.

In scheduled tasks / database backup / edit, I see no option to not turn the forum off. How would I do this?

Thanks. I really love this mod.

I'm going to check it tomorrow morning and see if it happens again tonight.

[djbaxter]

Originally Posted by melbo

In scheduled tasks / database backup / edit, I see no option to not turn the forum off. How would I do this?

Open /includes/mysqlbackupconfig.php.

Find at lines 8-10:

  //  Forum Shutdown System
  $backup['SHUTDOWN'] = 0;
  $backup['MESSAGE'] = "The Forum is closed because a database backup is in progress.";

Make sure that $backup['SHUTDOWN'] = 0.

[melbo]

thanks

[JohnBee]

Originally Posted by Paul M

You turn it on in the ACP.

It's not going to get "fixed" as there is nothing to fix, it's just a blip that sometimes happens. Like database errors.

Uninstalling it is a pointless and extreme route to take, just don't use the option if it bothers you. There is no need to close the forum during a backup.

Right... the problem is it was not off in ACP so there was nothing to turn on. It went away once the forums were turned off in ACP then back on again.

[djbaxter]

I've been running this mod for some time now, I think since 3.64 or maybe earlier.

This morning, I received an email warning with this error - the Backup add-on is the only cron job that would have been running at the time in question:

Database error in vBulletin 3.6.8:

Invalid SQL:
SHOW CREATE TABLE `vbtaggregate_temp_1195286160`;

MySQL Error : Table '{forum info deleted}.vbtaggregate_temp_1195286160' doesn't exist
Error Number : 1146
Date : Saturday, November 17th 2007 @ 03:44:40 AM
Script : http://{forum info deleted}/cron.php?&rand=961734
Referrer :
IP Address : {forum info deleted}
Username : Unregistered
Classname : vb_database

This is the first time I've seen this. Any ideas as to what caused it? I haven't changed anything that I can recall nor even added any new add-ons in at least several days.

[Paul M]

Looks like something created a temporary table, which had then been deleted by the time it came to be backed up.

[powerful_rogue]

This is fantastic. Although one problem. It only goes as far as announcementread before stopping. No errors or anything, it just stops. (Been doing it manually to test)

Ive read through the topic and seen people with a simialr problem who said it was to do with their host. As my host is usless as solving problems despite me paying a fortune each month, I decided to back up the normal way using VB's built in system. It came back with this:

Database Backup

Processing: access

Processing: adminhelp

Processing: administrator

Processing: adminlog

Processing: adminmessage

Processing: adminutil

Processing: adv_modules

Processing: adv_pages

Processing: adv_setting

Processing: adv_settinggroup

Processing: announcement

Processing: announcementread

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /includes/class_core.php on line 371
Database Error Database error
The Dover Locals database has encountered a problem.

Below is line 371-385

if ($queryresult = $this->functions[$buffered ? 'query' : 'query_unbuffered']($this->sql, $link))
{
// unset $sql to lower memory .. this isn't an error, so it's not needed
$this->sql = '';

return $queryresult;
}
else
{
$this->halt();

// unset $sql to lower memory .. error will have already been thrown
$this->sql = '';
}
}

Am I right in thinking this is definatly a problem with the server my site is hosted on? If so, what do I need to ask them?

All the best