Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB Database Backup (Lite) Details »»
vB Database Backup (Lite)
Version: 3.8.006, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 3.8.x Rating:
Released: 01-09-2009 Last Update: 11-25-2013 Installs: 553
Uses Plugins
Additional Files Translations  
No support by the author.

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

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, first for vb 3.6, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later in 2007 David gave me permission to release my adaptation.

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.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
4 благодарности(ей) от:
ITDarasgah, JimxJNM, Lemrith, M Shaker

Comments
  #382  
Old 10-03-2010, 01:39 PM
slowphantom's Avatar
slowphantom slowphantom is offline
 
Join Date: Jun 2006
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok Paul Thanks
i change it back and its working again now


Thank You
Reply With Quote
  #383  
Old 10-09-2010, 11:06 AM
d0zer's Avatar
d0zer d0zer is offline
 
Join Date: Apr 2009
Location: Hatay
Posts: 58
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Paul M
Reply With Quote
  #384  
Old 10-15-2010, 11:29 AM
Fynnon Fynnon is offline
 
Join Date: Jul 2008
Posts: 120
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is there a PRO version which sends the database to a mail address after beeing gzip-ed?
Reply With Quote
  #385  
Old 10-16-2010, 02:25 PM
faisalk's Avatar
faisalk faisalk is offline
 
Join Date: Oct 2010
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you Paul.
Reply With Quote
  #386  
Old 10-16-2010, 05:30 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Fynnon View Post
Is there a PRO version which sends the database to a mail address after beeing gzip-ed?
Nope.
Reply With Quote
  #387  
Old 11-21-2010, 11:17 AM
ITDarasgah's Avatar
ITDarasgah ITDarasgah is offline
 
Join Date: Mar 2009
Location: Pakistan
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Install and run manual show this
PHP Code:
Automatic Database Backup for vBulletin
Processing access 
(264) : Processed 264 Rows in 0.005 seconds
Processing action 
(No Row Data)
Processing adminhelp (1694) : Processed 1694 Rows in 0.045 seconds
Processing administrator 
(7) : Processed 7 Rows in 0 seconds
Processing adminlog 
(59083) : Processed 59083 Rows in 1.346 seconds
Processing adminmessage 
(No Row Data)
Processing adminutil (2) : Processed 2 Rows in 0 seconds
Processing album 
(4) : Processed 4 Rows in 0.001 seconds
Processing albumpicture 
(17) : Processed 17 Rows in 0 seconds
Processing albumupdate 
(No Row Data)
Processing announcement (2) : Processed 2 Rows in 0 seconds
Processing announcementread 
(154) : Processed 154 Rows in 0.002 seconds
Processing attachment 
(53112) : Processed 53112 Rows in 2.173 seconds
Processing attachmentcategory 
(No Row Data)
Processing attachmentcategoryuser (15217) : Processed 15217 Rows in 0.278 seconds
Processing attachmentpermission 
(25) : Processed 25 Rows in 0.001 seconds
Processing attachmenttype 
(18) : Processed 18 Rows in 0.001 seconds
Processing attachmentviews 
(No Row Data)
Processing avatar (No Row Data)
Processing bbcode (1) : Processed 1 Rows in 0 seconds
Processing bbcode_video 
(7) : Processed 7 Rows in 0 seconds
Processing bookmarksite 
(4) : Processed 4 Rows in 0 seconds
Processing cache 
(1) : Processed 1 Rows in 0 seconds
Processing cacheevent 
(3) : Processed 3 Rows in 0 seconds
Processing calendar 
(1) : Processed 1 Rows in 0 seconds
Processing calendarcustomfield 
(No Row Data)
Processing calendarmoderator (No Row Data)
Processing calendarpermission (No Row Data)
Processing contentpriority (No Row Data)
Processing contenttype (14) : Processed 14 Rows in 0.001 seconds
Processing cpsession 
(1) : Processed 1 Rows in 0.001 seconds
Processing cron 
(19) : Processed 19 Rows in 0.001 seconds
Processing cronlog 
(15362) : Processed 15362 Rows in 0.284 seconds
Processing customavatar 
(737) : Processed 737 Rows in 0.022 seconds
Processing customprofilepic 
(447) : Processed 447 Rows in 0.011 seconds
Processing cyb_logintouser 
(1) : Processed 1 Rows in 0 seconds
Processing datastore 
(32) : Processed 32 Rows in 0.081 seconds
Processing deletionlog 
(3683) : Processed 3683 Rows in 0.098 seconds
Processing discussion 
(No Row Data)
Processing discussionread (No Row Data)
Processing editlog (4348) : Processed 4348 Rows in 0.102 seconds
Processing event 
(5) : Processed 5 Rows in 0.001 seconds
Processing externalcache 
(No Row Data)
Processing faq (43) : Processed 43 Rows in 0.001 seconds
Processing filedata 
(14183) : Processed 14183 Rows in 0.607 seconds
Processing forum 
(193) : Processed 193 Rows in 0.02 seconds
Processing forumpermission 
(386) : Processed 386 Rows in 0.007 seconds
Processing forumprefixset 
(192) : Processed 192 Rows in 0.003 seconds
Processing forumread 
(No Row Data)
Processing groupmessage (No Row Data)
Processing groupmessage_hash (6) : Processed 6 Rows in 0.001 seconds
Processing groupread 
(No Row Data)
Processing holiday (No Row Data)
Processing humanverify (4) : Processed 4 Rows in 0 seconds
Processing hvanswer 
(No Row Data)
Processing hvquestion (1) : Processed 1 Rows in 0 seconds
Processing icon 
(36) : Processed 36 Rows in 0.001 seconds
Processing imagecategory 
(3) : Processed 3 Rows in 0 seconds
Processing imagecategorypermission 
(No Row Data

PHP Code:
Database error
******************************** database has encountered a problem.
Please try the following:

    * 
Load the page again by clicking the Refresh button in your web browser.
    * 
Open the www.itdarasgah.com home pagethen try to open another page.
    * 
Click the Back button to try another link.

The www.itdarasgah.com forum technical staff have been notified of the errorthough you may contact them if the problem persists.
 
We apologise for any inconvenience.
Database error in vBulletin 3.8.7 Beta 1Invalid SQLSHOW CREATE TABLE `indexqueue`; MySQL Error Incorrect file format 'indexqueue' Error Number 130 Request Date SundayNovember 21st 2010 07:08:16 AM Error Date SundayNovember 21st 2010 07:08:21 AM Script http://www.*******.com/******/cronadmin.php?do=runcron&cronid=50 Referrer : http://www.********.com/******/cronadmin.php?do=modify IP Address : ********** Username : ****** Classname : vB_Database MySQL Version : 5.0.91-community 
Reply With Quote
  #388  
Old 11-21-2010, 11:31 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You have an issue with a table called indexqueue - try repairing it.

Btw - that is not a standard table in vb 3.8.x
Reply With Quote
  #389  
Old 11-21-2010, 05:55 PM
ITDarasgah's Avatar
ITDarasgah ITDarasgah is offline
 
Join Date: Mar 2009
Location: Pakistan
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can you help me how can repair it .
and in my board its not run auto
Reply With Quote
  #390  
Old 11-21-2010, 10:54 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by SHER View Post
Can you help me how can repair it .
and in my board its not run auto
Use phpmyadmin to repair it - or even the repair option in the vbulletin ACP.

I dont really understand the last part of your post.
Reply With Quote
  #391  
Old 11-21-2010, 11:20 PM
ITDarasgah's Avatar
ITDarasgah ITDarasgah is offline
 
Join Date: Mar 2009
Location: Pakistan
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M View Post
Use phpmyadmin to repair it - or even the repair option in the vbulletin ACP.

I dont really understand the last part of your post.
Thank you Paul for reply , I mean this mod is not working for Automatic Backup just work manual but with the above errer . While I set time in Scheduled Task Manager
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 06:01 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.12442 seconds
  • Memory Usage 2,356KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (4)post_thanks_box_bit
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete