Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vB Database Backup Pro (Lite) for vb 3.6 Details »
vB Database Backup Pro (Lite) for vb 3.6
Mod Version: 2.12, by Paul M (Member) Paul M is offline
Developer Last Online: Jan 2018 I like it Show Printable Version Email this Page

This thread is in the Modification Graveyard.
vB Version: 3.6.x Rating: (41 votes - 4.66 average) Installs: 582
Released: 18 Sep 2006 Last Update: 10 Oct 2006 Downloads: 3334
Not Supported Auto-Template Additional Files Re-usable Code Translations  

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.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #511  
Old 06 Jan 2008, 13:22
SpArKs85 SpArKs85 is offline
 
Join Date: Dec 2006
Originally Posted by Paul M View Post
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.

Last edited by SpArKs85; 06 Jan 2008 at 13:28.
Reply With Quote
  #512  
Old 06 Jan 2008, 15:26
edgecutioner edgecutioner is offline
 
Join Date: Jul 2007
Location: Qatar
Real name: ???
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?
Reply With Quote
  #513  
Old 06 Jan 2008, 15:44
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by SpArKs85 View Post
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 View Post
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 View Post
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.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #514  
Old 06 Jan 2008, 15:54
SpArKs85 SpArKs85 is offline
 
Join Date: Dec 2006
Originally Posted by Paul M View Post
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?
Reply With Quote
  #515  
Old 06 Jan 2008, 16:09
SpArKs85 SpArKs85 is offline
 
Join Date: Dec 2006
Originally Posted by SpArKs85 View Post
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
Reply With Quote
  #516  
Old 25 Jan 2008, 11:16
afullcup afullcup is offline
 
Join Date: Jul 2006
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.
Reply With Quote
  #517  
Old 25 Jan 2008, 12:42
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
There is no way this could have any effect on that.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #518  
Old 25 Jan 2008, 13:30
afullcup afullcup is offline
 
Join Date: Jul 2006
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. ?
Reply With Quote
  #519  
Old 25 Jan 2008, 16:55
pedroenf pedroenf is offline
 
Join Date: Jun 2006
Real name: Pedro
Excelent mod. Installed. Thank you Paul. Regards.
Reply With Quote
  #520  
Old 25 Jan 2008, 17:32
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by afullcup View Post
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 ?
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #521  
Old 29 Jan 2008, 20:36
LorinPotter LorinPotter is offline
 
Join Date: Jan 2008
Something I didn't find anywhere in this thread is how do you use this backup to do a restore?
TIA
Reply With Quote
  #522  
Old 30 Jan 2008, 01:22
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by LorinPotter View Post
Something I didn't find anywhere in this thread is how do you use this backup to do a restore?
TIA
You don't. You import the SQL files via phpMyAdmin.
Reply With Quote
  #523  
Old 30 Jan 2008, 08:00
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
or better still, using SSH (if you have access).
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #524  
Old 30 Jan 2008, 10:00
peterpigman peterpigman is offline
 
Join Date: May 2006
Will this work on a large db 400+mb?
__________________
Uncover Reality
Reply With Quote
  #525  
Old 30 Jan 2008, 17:14
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Yes.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 21:52.

Layout Options | Width: Wide Color: