Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vBulletin Cron Based Database Backup Details »
vBulletin Cron Based Database Backup
Mod Version: 4.2.0.2, 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: 4.2.x Rating: (160 votes - 4.89 average) Installs: 1436
Released: 28 Dec 2009 Last Update: 26 Nov 2013 Downloads: 7175
Not Supported Uses Plugins Additional Files Translations  

As of 23 Nov 2017 this modification has been withdrawn.

This is a cut down version based on a backup system written by Trigunflame for vb 3.0. It is a simple vBulletin cron trigged php system that does a dump of your database - either as one complete file, or as one file per table. Especially useful now that IB removed the old ACP backup option in vBulletin 4. Files can be (G)Zipped to save space.

All the options are located in the ACP in vBulletin Options >> vBulletin Automatic Backup

To install, download and unzip the files, and follow the instructions in the text file.


History:

v4.0.1 : 28-Dec-2009 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.
v4.0.3 : 27-Jun-2010 : Added Gzip option.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.0.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.
v4.2.0.1 : 17-Mar-2013 : Removed vboptions from backup call..
v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added mysqldump backup.

Download Now

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

Addons

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.
Similar Mod
Mod Developer Type Replies Last Post
Vbulletin Database Backup Pro (Cron Support) Trigunflame vBulletin 3.0 Full Releases 443 05 Sep 2008 16:12

  #991  
Old 01 Sep 2014, 17:18
doogie88 doogie88 is offline
 
Join Date: Oct 2006
Thanks. That's exactly what I needed too! Filled my server HD after several months of backups!
Reply With Quote
  #992  
Old 03 Sep 2014, 01:24
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Its a trick covered many times in this thread, right back to 2010

http://www.vbulletin.org/forum/showt...23#post1997323
__________________
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
  #993  
Old 03 Sep 2014, 01:33
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
Originally Posted by Paul M View Post
Its a trick covered many times in this thread, right back to 2010

http://www.vbulletin.org/forum/showt...23#post1997323
Just one of the thousands of good tips I must have over looked.

Feel free to remind me anytime though because I am getting old.
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #994  
Old 15 Sep 2014, 16:51
delds delds is offline
 
Join Date: Oct 2003
After just going through an almost 2 day down time after accidentally deleting the wrong database, and finding out that the host which I had paid extra for weekly backups, and now finding out their 2 most recent backups that some tables missing and needing to go back more than 3 weeks to get a backup that had all the tables, I have grown a distrust on counting on the host backups only.

This really works well, just installed it and tried it and it works great.

I have 2 questions, is there a way to set daily auto backups or do I only have the options of weekly? Manual backups can be run at any time.

2nd Is it possible to remove the date prefex on the tables when backed up so for example it would backuup
access.sql
as
access.sql and not 2014-09-15-Access.sql ??

If I ever had to re upload I would not want the prefix on the tables and would have to rename each one first.
The folder gets names by date do I really need the tables with the prefex also?

next when downloading it to my local computer what mode should it be in ascii or binary?
Reply With Quote
  #995  
Old 15 Sep 2014, 17:37
bzcomputers's Avatar
bzcomputers bzcomputers is offline
 
Join Date: Apr 2012
Originally Posted by delds View Post
I have 2 questions, is there a way to set daily auto backups or do I only have the options of weekly? Manual backups can be run at any time.

2nd Is it possible to remove the date prefex on the tables when backed up so for example it would backuup
access.sql
as
access.sql and not 2014-09-15-Access.sql ??

If I ever had to re upload I would not want the prefix on the tables and would have to rename each one first.
The folder gets names by date do I really need the tables with the prefex also?

next when downloading it to my local computer what mode should it be in ascii or binary?
Yes, this mod is automatically set for doing daily backups. You need to adjust the "Date Format" option to set how many backups you would like to keep. You will find information on this at this link in the settings: http://uk.php.net/manual/en/function.date.php. What you may have currently set is "W" which will save each backup as the week number of the year. With a setting of "W" every daily backup for 7 days will overwrite itself when created and at the end of the year you will have 52 backups (probably not what you are looking for). I recommend a setting of "D" which will save your backups by day of the week. So you'll have one backup for each day of the week and the following week the backups will begin to overwrite each other. This way you will never have more than 7 backups saved.

Second, the prefix is just added to the file names, the tables contained within the .sql files are unchanged (no prefix added).

Last, when transferring use binary to be safe. Ascii transfers everything as a regular text file which can corrupt some data within the database. I also highly recommend using the option to combine all tables into one backup file and using Gzip. Less chance of issues all the way around.
Reply With Quote
  #996  
Old 15 Sep 2014, 18:17
delds delds is offline
 
Join Date: Oct 2003
Thanks, I believe I have it set to auto backup every morning at 4 am. Single file backup of database gzip version, on the manual run it appears to backup perfectly. Will download to local computer in binary mode.

What software can I use on the local computer just to decompress to test that all tables are present?
Reply With Quote
  #997  
Old 15 Sep 2014, 18:30
bzcomputers's Avatar
bzcomputers bzcomputers is offline
 
Join Date: Apr 2012
Originally Posted by delds View Post
What software can I use on the local computer just to decompress to test that all tables are present?
DbVisualizer it has a 21 day free trial which you can download here: http://www.dbvis.com/
There are other programs out there also.

You can always just re-import into mysql as a different database name and view it all there also, then just delete the database when you're done (be careful you're deleting the right database!).
Reply With Quote
  #998  
Old 16 Sep 2014, 12:33
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by delds View Post
Is it possible to remove the date prefex on the tables when backed up so for example it would backuup
access.sql
as
access.sql and not 2014-09-15-Access.sql ??
That prefix is only on the filename, not the actual backed up table within 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
  #999  
Old 21 Sep 2014, 17:19
chikuru chikuru is offline
 
Join Date: Nov 2011
doesnt work on PHP 5.3.2
the window just display blank when clicking RUn Now from scheduled task..
Reply With Quote
  #1000  
Old 21 Sep 2014, 20:08
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Sorry, but you are wrong.

It runs perfectly fine on php 5.2, 5.3, 5.4, 5.5 & 5.6

In fact when I first wrote it, and started using it, I was still on php 4.x
__________________
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
  #1001  
Old 21 Sep 2014, 21:12
chikuru chikuru is offline
 
Join Date: Nov 2011
what could be the cause of the blank page?
i tried changing the var to mysql also.
is there any way to log the error?
Reply With Quote
  #1002  
Old 21 Sep 2014, 21:17
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
Check your server error logs. If you don't know where they are, ask your host.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #1003  
Old 31 Oct 2014, 23:02
john7911 john7911 is offline
 
Join Date: Feb 2013
Hi,
When I download an sql my forum does not work

what is the problem?
Thank you
Reply With Quote
  #1004  
Old 01 Nov 2014, 19:43
john7911 john7911 is offline
 
Join Date: Feb 2013
any solution?
Reply With Quote
  #1005  
Old 01 Nov 2014, 20:04
tbworld tbworld is offline
 
Join Date: Oct 2008
You would have to leave us more details on what you did. How did you restore the database? What was the reason you had to restore your database from a backup?

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 04:31.

Layout Options | Width: Wide Color: