vb.org Archive
Page 68 of 107 « First 18586667 68 697078 Last »
Show 40 post(s) from this thread on one page

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

Mariner1 07-04-2012 09:15 AM
Im using 4.1.2
Which ver is best to download and install pls

cloferba 07-08-2012 12:54 PM
Can I make 2 backups, one file for each table and other with the full database?

davidg 07-08-2012 01:36 PM
Quote:
Originally Posted by JMEWLS` (Post 2344963)
HTML Code:
Processing access (1) [Compressing File] : Processed 1 Rows in 0.029 Seconds
Processing action (18) [Compressing File] : Processed 18 Rows in 0.022 Seconds
Processing activitystream (13761) [Compressing File] : Processed 13761 Rows in 0.766 Seconds
Processing activitystreamtype (16) [Compressing File] : Processed 16 Rows in 0.005 Seconds
Processing ad (3) [Compressing File] : Processed 3 Rows in 0.023 Seconds
Processing adcriteria (No Row Data) [Compressing File]
Processing adminhelp (1801) [Compressing File] : Processed 1801 Rows in 0.091 Seconds
Processing administrator (3) [Compressing File] : Processed 3 Rows in 0.005 Seconds
Processing adminlog (7557) [Compressing File] : Processed 7557 Rows in 0.828 Seconds
Processing adminmessage (3) [Compressing File] : Processed 3 Rows in 0.077 Seconds
Processing adminutil (7) [Compressing File] : Processed 7 Rows in 0.096 Seconds
Processing album (8) [Compressing File] : Processed 8 Rows in 0.016 Seconds
Processing albumupdate (No Row Data) [Compressing File]
Processing announcement (3) [Compressing File] : Processed 3 Rows in 0.104 Seconds
Processing announcementread (112) [Compressing File] : Processed 112 Rows in 0.007 Seconds
Processing apiclient (No Row Data) [Compressing File]
Processing apilog (No Row Data) [Compressing File]
Processing apipost (No Row Data) [Compressing File]
Processing attachment (116) [Compressing File] : Processed 116 Rows in 0.065 Seconds
Processing attachmentcategory (No Row Data) [Compressing File]
Processing attachmentcategoryuser (115) [Compressing File] : Processed 115 Rows in 0.039 Seconds
Processing attachmentpermission (No Row Data) [Compressing File]
Processing attachmenttype (11) [Compressing File] : Processed 11 Rows in 0.026 Seconds
Processing attachmentviews (No Row Data) [Compressing File]
Processing autosave (1031) [Compressing File] : Processed 1031 Rows in 0.142 Seconds
Processing avatar (No Row Data) [Compressing File]
Processing bbcode (No Row Data) [Compressing File]
Processing bbcode_video (8) [Compressing File] : Processed 8 Rows in 0.125 Seconds
Processing block (12) [Compressing File] : Processed 12 Rows in 0.027 Seconds
Processing blockconfig (39) [Compressing File] : Processed 39 Rows in 0.045 Seconds
Processing blocktype (6) [Compressing File] : Processed 6 Rows in 0.017 Seconds
Processing blog (No Row Data) [Compressing File]
Processing blog_attachmentlegacy (No Row Data) [Compressing File]
Processing blog_category (No Row Data) [Compressing File]
Processing blog_categorypermission (No Row Data) [Compressing File]
Processing blog_categoryuser (No Row Data) [Compressing File]
Processing blog_custom_block (No Row Data) [Compressing File]
Processing blog_custom_block_parsed (No Row Data) [Compressing File]
Processing blog_deletionlog (No Row Data) [Compressing File]
Processing blog_editlog (No Row Data) [Compressing File]
Processing blog_featured (No Row Data) [Compressing File]
Processing blog_groupmembership (No Row Data) [Compressing File]
Processing blog_grouppermission (No Row Data) [Compressing File]
Processing blog_hash (No Row Data) [Compressing File]
Processing blog_moderation (No Row Data) [Compressing File]
Processing blog_moderator (No Row Data) [Compressing File]
Processing blog_pinghistory (No Row Data) [Compressing File]
Processing blog_rate (No Row Data) [Compressing File]
Processing blog_read (No Row Data) [Compressing File]
Processing blog_relationship (No Row Data) [Compressing File]
Processing blog_search (No Row Data) [Compressing File]
Processing blog_searchresult (No Row Data) [Compressing File]
Processing blog_sitemapconf (No Row Data) [Compressing File]
Processing blog_subscribeentry (No Row Data) [Compressing File]
Processing blog_subscribeuser (No Row Data) [Compressing File]
Processing blog_summarystats (No Row Data) [Compressing File]
Processing blog_tachyentry (No Row Data) [Compressing File]
Processing blog_text (No Row Data) [Compressing File]
Processing blog_textparsed (No Row Data) [Compressing File]
Processing blog_trackback (No Row Data) [Compressing File]
Processing blog_trackbacklog (No Row Data) [Compressing File]
Processing blog_user (55) [Compressing File] : Processed 55 Rows in 0.017 Seconds
Processing blog_usercss (No Row Data) [Compressing File]
Processing blog_usercsscache (No Row Data) [Compressing File]
Processing blog_userread (No Row Data) [Compressing File]
Processing blog_userstats (No Row Data) [Compressing File]
Processing blog_views (No Row Data) [Compressing File]
Processing blog_visitor (No Row Data) [Compressing File]
Processing bookmarksite (4) [Compressing File] : Processed 4 Rows in 0.006 Seconds
Processing cache (649) [Compressing File] : Processed 649 Rows in 2.934 Seconds
Processing cacheevent (878) [Compressing File] : Processed 878 Rows in 0.031 Seconds
Processing calendar (1) [Compressing File] : Processed 1 Rows in 0.017 Seconds
Processing calendarcustomfield (No Row Data) [Compressing File]
Processing calendarmoderator (No Row Data) [Compressing File]
Processing calendarpermission (No Row Data) [Compressing File]
Processing cms_article (255) [Compressing File] : Processed 255 Rows in 0.131 Seconds
Processing cms_category (No Row Data) [Compressing File]
Processing cms_grid (2) [Compressing File] : Processed 2 Rows in 0.012 Seconds
Processing cms_layout (1) [Compressing File] : Processed 1 Rows in 0.004 Seconds
Processing cms_layoutwidget (11) [Compressing File] : Processed 11 Rows in 0.005 Seconds
Processing cms_navigation (214) [Compressing File] : Processed 214 Rows in 0.016 Seconds
Processing cms_node (214) [Compressing File] : Processed 214 Rows in 0.032 Seconds
Processing cms_nodecategory (No Row Data) [Compressing File]
Processing cms_nodeconfig (5) [Compressing File] : Processed 5 Rows in 0.036 Seconds
Processing cms_nodeinfo (214) [Compressing File] : Processed 214 Rows in 0.025 Seconds
Processing cms_permissions (18) [Compressing File] : Processed 18 Rows in 0.005 Seconds
Processing cms_rate (No Row Data) [Compressing File]
Processing cms_sectionorder (No Row Data) [Compressing File]
Processing cms_widget (14) [Compressing File] : Processed 14 Rows in 0.005 Seconds
Processing cms_widgetconfig (45) [Compressing File] : Processed 45 Rows in 0.006 Seconds
Processing cms_widgettype (21) [Compressing File] : Processed 21 Rows in 0.013 Seconds
Processing contentpriority (No Row Data) [Compressing File]
Processing contentread (1713) [Compressing File] : Processed 1713 Rows in 0.1 Seconds
Processing contenttype (28) [Compressing File] : Processed 28 Rows in 0.006 Seconds
Processing cpsession (1) [Compressing File] : Processed 1 Rows in 0.004 Seconds
Processing cron (31) [Compressing File] : Processed 31 Rows in 0.006 Seconds
Processing cronlog (54518) [Compressing File] : Processed 54518 Rows in 3.846 Seconds
Processing customavatar (343) [Compressing File] : Processed 343 Rows in 0.912 Seconds
Processing customprofile (4) [Compressing File] : Processed 4 Rows in 0.013 Seconds
Processing customprofilepic (238) [Compressing File] : Processed 238 Rows in 0.27 Seconds
Processing datastore (40) [Compressing File] : Processed 40 Rows in 0.05 Seconds
Processing dbquery (No Row Data) [Compressing File]
Processing deletionlog (2054) [Compressing File] : Processed 2054 Rows in 0.114 Seconds
Processing discussion (4) [Compressing File] : Processed 4 Rows in 0.006 Seconds
Processing discussionread (No Row Data) [Compressing File]
Processing editlog (8432) [Compressing File] : Processed 8432 Rows in 0.34 Seconds
Processing event (1) [Compressing File] : Processed 1 Rows in 0.013 Seconds
Processing externalcache (No Row Data) [Compressing File]
Processing faq (80) [Compressing File] : Processed 80 Rows in 0.016 Seconds
Processing filedata (115) [Compressing File] : Processed 115 Rows in 1.041 Seconds
Processing forum (115) [Compressing File] : Processed 115 Rows in 0.021 Seconds
Processing forumpermission (36) [Compressing File] : Processed 36 Rows in 0.017 Seconds
Processing forumprefixset (1) [Compressing File] : Processed 1 Rows in 0.011 Seconds
Processing forumread (No Row Data) [Compressing File]
Processing forumrunner_push_data (No Row Data) [Compressing File]
Processing forumrunner_push_users (No Row Data) [Compressing File]
Processing gcbos (30) [Compressing File] : Processed 30 Rows in 0.032 Seconds
Processing glowhostspamomatic_log (39214) [Compressing File] : Processed 39214 Rows in 4.184 Seconds
Processing glowhostspamomatic_remotecache (307) [Compressing File] : Processed 307 Rows in 0.248 Seconds
Processing glowhostspamomatic_stats (1) [Compressing File] : Processed 1 Rows in 0.112 Seconds
Processing groupmessage (14) [Compressing File] : Processed 14 Rows in 0.006 Seconds
Processing groupmessage_hash (No Row Data) [Compressing File]
Processing groupread (No Row Data) [Compressing File]
Processing holiday (No Row Data) [Compressing File]
Processing humanverify (24) [Compressing File] : Processed 24 Rows in 0.053 Seconds
Processing hvanswer (5) [Compressing File] : Processed 5 Rows in 0.045 Seconds
Processing hvquestion (2) [Compressing File] : Processed 2 Rows in 0.102 Seconds
Processing icon (62) [Compressing File] : Processed 62 Rows in 0.134 Seconds
Processing imagecategory (3) [Compressing File] : Processed 3 Rows in 0.007 Seconds
Processing imagecategorypermission (No Row Data) [Compressing File]
Processing indexqueue (No Row Data) [Compressing File]
Processing infraction (8) [Compressing File] : Processed 8 Rows in 0.005 Seconds
Processing infractionban (No Row Data) [Compressing File]
Processing infractiongroup (No Row Data) [Compressing File]
Processing infractionlevel (4) [Compressing File] : Processed 4 Rows in 0.016 Seconds
Processing ipdata (1713) [Compressing File] : Processed 1713 Rows in 0.194 Seconds
Processing language (1) [Compressing File] : Processed 1 Rows in 0.165 Seconds
Processing mailqueue (No Row Data) [Compressing File]
Processing moderation (9327) [Compressing File] : Processed 9327 Rows in 0.332 Seconds
Processing moderator (19) [Compressing File] : Processed 19 Rows in 0.005 Seconds
Processing moderatorlog (56661) [Compressing File] : Processed 56661 Rows in 6.044 Seconds
Processing navigation (40) [Compressing File] : Processed 40 Rows in 0.041 Seconds
Processing notice (4) [Compressing File] : Processed 4 Rows in 0.029 Seconds
Processing noticecriteria (4) [Compressing File] : Processed 4 Rows in 0.059 Seconds
Processing noticedismissed (151) [Compressing File] : Processed 151 Rows in 0.008 Seconds
Processing package (3) [Compressing File] : Processed 3 Rows in 0.005 Seconds
Processing passwordhistory (6096) [Compressing File] : Processed 6096 Rows in 0.241 Seconds
Processing paymentapi (7) [Compressing File] : Processed 7 Rows in 0.006 Seconds
Processing paymentinfo (No Row Data) [Compressing File]
Processing paymenttransaction (No Row Data) [Compressing File]
Processing phrase (16538) [Compressing File] : Processed 16538 Rows in 1.121 Seconds
Processing phrasetype (78) [Compressing File] : Processed 78 Rows in 0.008 Seconds
Processing picturecomment (27) [Compressing File] : Processed 27 Rows in 0.017 Seconds
Processing picturecomment_hash (No Row Data) [Compressing File]
Processing picturelegacy (No Row Data) [Compressing File]
Processing plugin (204) [Compressing File] : Processed 204 Rows in 0.056 Seconds
Processing pm (2514) [Compressing File] : Processed 2514 Rows in 0.11 Seconds
Processing pmreceipt (12) [Compressing File] : Processed 12 Rows in 0.008 Seconds
Processing pmtext (2178) [Compressing File] : Processed 2178 Rows in 0.474 Seconds
Processing pmthrottle (No Row Data) [Compressing File]
Processing podcast (No Row Data) [Compressing File]
Processing podcastitem (No Row Data) [Compressing File]
Processing poll (204) [Compressing File] : Processed 204 Rows in 0.089 Seconds
Processing pollvote (1656) [Compressing File] : Processed 1656 Rows in 0.11 Seconds
Processing post (317671) [Compressing File] : Processed 317671 Rows in 33.858 Seconds
Processing postedithistory (26315) [Compressing File] : Processed 26315 Rows in 4.321 Seconds
Processing posthash (7) [Compressing File] : Processed 7 Rows in 0.026 Seconds
Processing postlog (3594) [Compressing File] : Processed 3594 Rows in 0.521 Seconds
Processing postparsed (11992) [Compressing File] : Processed 11992 Rows in 1.427 Seconds
Processing postrelease (1) [Compressing File] : Processed 1 Rows in 0.14 Seconds
Processing prefix (5) [Compressing File] : Processed 5 Rows in 0.074 Seconds
Processing prefixpermission (No Row Data) [Compressing File]
Processing prefixset (1) [Compressing File] : Processed 1 Rows in 0.089 Seconds
Processing product (15) [Compressing File] : Processed 15 Rows in 0.005 Seconds
Processing productcode (23) [Compressing File] : Processed 23 Rows in 0.02 Seconds
Processing productdependency (9) [Compressing File] : Processed 9 Rows in 0.006 Seconds
Processing profileblockprivacy (80) [Compressing File] : Processed 80 Rows in 0.007 Seconds
Processing profilefield (6) [Compressing File] : Processed 6 Rows in 0.005 Seconds
Processing profilefieldcategory (No Row Data) [Compressing File]
Processing profilevisitor (4631) [Compressing File] : Processed 4631 Rows in 0.12 Seconds
Processing ranks (7) [Compressing File] : Processed 7 Rows in 0.014 Seconds
Processing reminder (No Row Data) [Compressing File]
Processing reputation (1268) [Compressing File] : Processed 1268 Rows in 0.062 Seconds
Processing reputationlevel (15) [Compressing File] : Processed 15 Rows in 0.027 Seconds
Processing route (4) [Compressing File] : Processed 4 Rows in 0.028 Seconds
Processing rssfeed (40) [Compressing File] : Processed 40 Rows in 0.008 Seconds
Processing rsslog (48182) [Compressing File] : Processed 48182 Rows in 2.455 Seconds
Processing searchcore (391069) [Compressing File]
Keeps timing out here. Switched on block processing. Not sure what else to do.

maybe change your hosting?

Paul M 07-08-2012 01:46 PM
Quote:
Originally Posted by JMEWLS` (Post 2344963)
Keeps timing out here. Switched on block processing. Not sure what else to do.
Change your script timeout settings (assuming you can).

cloferba 07-08-2012 02:26 PM
Quote:
Originally Posted by cloferba (Post 2346044)
Can I make 2 backups, one file for each table and other with the full database?
Hello Paul, could you please answer this?

I always prefer to backup each table separately, but in some cases a lot of tables are compromised and I can?t restore each table. The last week I had to do that and I spent 30 minutes restoring each table....

Paul M 07-08-2012 08:48 PM
You have the choice of either.

eva2000 07-09-2012 09:03 AM
Hey Paul, probably not that hard to add pigz as alternative to gzip compression ? pigz parallel version of gzip up to 33x times faster than gzip http://vbtechsupport.com/2094/ :D

Paul M 07-10-2012 12:49 AM
How many servers are likely to have that installed ? Ive never heard of it until today.

JMEWLS` 07-10-2012 03:58 AM
Quote:
Originally Posted by Paul M (Post 2346067)
Change your script timeout settings (assuming you can).
I can't anymore suggestions.

eva2000 07-10-2012 05:52 AM
Quote:
Originally Posted by Paul M (Post 2346538)
How many servers are likely to have that installed ? Ive never heard of it until today.
hard to say right now, but whm/cpanel are looking into replacing all there backup functions using gzip and switching to pigz http://forums.cpanel.net/f145/faster...-a-242831.html, so imagine every cpanel/whm based server online with pigz support in future. I'd say quite a few will have pigz eventually :D


All times are GMT. The time now is 06:45 AM.
Page 68 of 107 « First 18586667 68 697078 Last »
Show 40 post(s) from this thread on one page

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.02064 seconds
  • Memory Usage 1,815KB
  • 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_html_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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