vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - vB Database Backup (Lite) (https://vborg.vbsupport.ru/showthread.php?t=201319)

ITDarasgah 11-22-2010 12:09 AM

After delete that table and Run manual its work and stop after this is this is complete or not
PHP Code:

Automatic Database Backup for vBulletin
Processing access 
(265) : Processed 265 Rows in 0.004 seconds
Processing action 
(No Row Data)
Processing adminhelp (1694) : Processed 1694 Rows in 0.037 seconds
Processing administrator 
(7) : Processed 7 Rows in 0.001 seconds
Processing adminlog 
(59227) : Processed 59227 Rows in 1.355 seconds
Processing adminmessage 
(No Row Data)
Processing adminutil (2) : Processed 2 Rows in 0 seconds
Processing album 
(4) : Processed 4 Rows in 0 seconds
Processing albumpicture 
(17) : Processed 17 Rows in 0.001 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 
(53150) : Processed 53150 Rows in 2.231 seconds
Processing attachmentcategory 
(No Row Data)
Processing attachmentcategoryuser (15217) : Processed 15217 Rows in 0.274 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.003 seconds
Processing cron 
(19) : Processed 19 Rows in 0.002 seconds
Processing cronlog 
(15391) : Processed 15391 Rows in 0.295 seconds
Processing customavatar 
(738) : Processed 738 Rows in 0.023 seconds
Processing customprofilepic 
(449) : Processed 449 Rows in 0.011 seconds
Processing cyb_logintouser 
(1) : Processed 1 Rows in 0 seconds
Processing datastore 
(32) : Processed 32 Rows in 0.018 seconds
Processing deletionlog 
(3683) : Processed 3683 Rows in 0.089 seconds
Processing discussion 
(No Row Data)
Processing discussionread (No Row Data)
Processing editlog (4353) : Processed 4353 Rows in 0.094 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.59 seconds
Processing forum 
(193) : Processed 193 Rows in 0.019 seconds
Processing forumpermission 
(386) : Processed 386 Rows in 0.006 seconds
Processing forumprefixset 
(192) : Processed 192 Rows in 0.002 seconds
Processing forumread 
(No Row Data)
Processing groupmessage (No Row Data)
Processing groupmessage_hash (6) : Processed 6 Rows in 0 seconds
Processing groupread 
(No Row Data)
Processing holiday (No Row Data)
Processing humanverify (4) : Processed 4 Rows in 0.001 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)
Processing infraction (168) : Processed 168 Rows in 0.007 seconds
Processing infractionban 
(1) : Processed 1 Rows in 0 seconds
Processing infractiongroup 
(No Row Data)
Processing infractionlevel (4) : Processed 4 Rows in 0 seconds
Processing language 
(1) : Processed 1 Rows in 0.008 seconds
Processing mailqueue 
(No Row Data)
Processing memberviews (No Row Data)
Processing membervisits (No Row Data)
Processing moderation (74) : Processed 74 Rows in 0.001 seconds
Processing moderator 
(171) : Processed 171 Rows in 0.004 seconds
Processing moderatorlog 
(82662) : Processed 82662 Rows in 4.363 seconds
Processing notice 
(9) : Processed 9 Rows in 0.001 seconds
Processing noticecriteria 
(14) : Processed 14 Rows in 0.001 seconds
Processing noticedismissed 
(776) : Processed 776 Rows in 0.009 seconds
Processing package 
(1) : Processed 1 Rows in 0 seconds
Processing passwordhistory 
(25487) : Processed 25487 Rows in 0.367 seconds
Processing paymentapi 
(7) : Processed 7 Rows in 0.001 seconds
Processing paymentinfo 
(No Row Data)
Processing paymenttransaction (No Row Data)
Processing phrase (11999) : Processed 11999 Rows in 0.37 seconds
Processing phrasetype 
(67) : Processed 67 Rows in 0.002 seconds
Processing picture 
(17) : Processed 17 Rows in 0.005 seconds
Processing picturecomment 
(No Row Data)
Processing picturecomment_hash (No Row Data)
Processing picturelegacy (17) : Processed 17 Rows in 0.001 seconds
Processing plugin 
(251) : Processed 251 Rows in 0.01 seconds
Processing pm 
(300027) : Processed 300027 Rows in 6.285 seconds
Processing pmreceipt 
(14) : Processed 14 Rows in 0.001 seconds
Processing pmtext 
(15087) : Processed 15087 Rows in 0.695 seconds
Processing pmthrottle 
(No Row Data)
Processing podcast (No Row Data)
Processing podcastitem (No Row Data)
Processing poll (129) : Processed 129 Rows in 0.005 seconds
Processing pollvote 
(3190) : Processed 3190 Rows in 0.065 seconds
Processing post 
(726386) : Processed 726386 Rows in 38.915 seconds
Processing post_thanks 
(123861) : Processed 123861 Rows in 2.35 seconds
Processing postedithistory 
(9949) : Processed 9949 Rows in 0.421 seconds
Processing posthash 
(8) : Processed 8 Rows in 0.001 seconds
Processing postindex 
(9087571


and please guide me how can set for daily backup on 2:00 AM

Paul M 11-22-2010 08:36 PM

No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb] scheduled task. You just need to alter the time of it.

ITDarasgah 11-24-2010 10:32 PM

Quote:

Originally Posted by Paul M (Post 2124774)
No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb] scheduled task. You just need to alter the time of it.

Thanks for reply:)
I did not find that mod You can identify or give me the link

Paul M 11-25-2010 11:14 AM

What mod ?

ITDarasgah 11-25-2010 11:28 AM

Quote:

Originally Posted by Paul M (Post 2124774)
No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb]

I am saying about that..:)

snowlion 11-25-2010 12:48 PM

Quote:

Originally Posted by SHER (Post 2125598)
I am saying about that..:)

He is talking about this mod :D

Paul M 11-25-2010 01:33 PM

Quote:

Originally Posted by SHER (Post 2125598)
I am saying about that..:)

Quote:

Originally Posted by snowlion (Post 2125613)
He is talking about this mod :D

Yep. :)

ITDarasgah 11-25-2010 02:52 PM

Quote:

Originally Posted by snowlion (Post 2125613)
He is talking about this mod :D

Quote:

Originally Posted by Paul M (Post 2125625)
Yep. :)

:eek::p
Then give me an Advice about the time out, What should I do?

Paul M 11-25-2010 04:04 PM

TBH, I suggest you switch to using the mysql full text search, and empty out the old search tables (of which postindex is one).

ITDarasgah 11-25-2010 07:30 PM

Quote:

Originally Posted by Paul M (Post 2125666)
TBH, I suggest you switch to using the mysql full text search, and empty out the old search tables (of which postindex is one).

Thank you :)

but how , Unfortunately I am not programmer can tell you in detail I am thankful to you.

I'm sorry to waste your time


All times are GMT. The time now is 02:57 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01559 seconds
  • Memory Usage 1,795KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete