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.

[SpArKs85]

Originally Posted by Paul M

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

Figures... How do I unlock it? I mean, if I manually run the task, it shouldn't be any different to a scheduled run correct? When ever I manually run the script the datastore is always locked. So I would assume it is or has been permanently locked. How would I remedy this?

Thanks Paul.

[edgecutioner]

This mod kinda ruins your skins, I noticed that after a few restores so if you had this problem, don't worry, just rebuild your styles on the "Update counters" and rebuild your styles and everything will be fine
--------------
Paul, is there any way to run this mod more than one time a day? If so, can you guide me please?

[Paul M]

Originally Posted by SpArKs85

Figures... How do I unlock it? I mean, if I manually run the task, it shouldn't be any different to a scheduled run correct? When ever I manually run the script the datastore is always locked. So I would assume it is or has been permanently locked. How would I remedy this?

There is no way I can tell you what is locking it. Something has a read lock, the message is a bit odd to me because normally I would expect mysql to just queue the write, and process it when the read lock has gone.

Originally Posted by edgecutioner

This mod kinda ruins your skins, I noticed that after a few restores so if you had this problem, don't worry, just rebuild your styles on the "Update counters" and rebuild your styles and everything will be fine

This mod cannot effect skins as such, its read only. My guess is you store your css in files so you need to rebuild those files after a restore.

Originally Posted by edgecutioner

Paul, is there any way to run this mod more than one time a day? If so, can you guide me please?

You can run it as often as a VB cron will allow (hourly if you want). However you will need to change the Time setting in the config so that the files have a unique timestamp, otherwise each run will overwrite the previous.

[SpArKs85]

Originally Posted by Paul M

There is no way I can tell you what is locking it. Something has a read lock, the message is a bit odd to me because normally I would expect mysql to just queue the write, and process it when the read lock has gone.

I have moved folders around on my server and all the files and folders are set to 705. I'm sure it has to be 755 or something? Could this be the cause?

[SpArKs85]

Originally Posted by SpArKs85

I have moved folders around on my server and all the files and folders are set to 705. I'm sure it has to be 755 or something? Could this be the cause?

Fixed: incorrect dump path in mysqlbackupconfig.php

[afullcup]

I have a strange problem with this hack. Each morning after this runs, the hover preview does not work (when you hover over a thread name and get a preview of the thread). Any clue what this might be conflicting with? thanks.

[Paul M]

There is no way this could have any effect on that.

[afullcup]

I thought it odd as well but disabled it and didn't have the problem anymore. After a week or so I enabled it again last night and this morning had the same issue. ?

[pedroenf]

Excelent mod. Installed. Thank you Paul. Regards.

[Paul M]

Originally Posted by afullcup

I thought it odd as well but disabled it and didn't have the problem anymore. After a week or so I enabled it again last night and this morning had the same issue. ?

So how do you fix it ?