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 - vBulletin Cron Based Database Backup (https://vborg.vbsupport.ru/showthread.php?t=231481)

KissOfDeath 03-06-2010 05:50 AM

Thank you very much, i'm not sure why they took this feature away, it's a must have

Ragman68 03-07-2010 06:21 PM

thank you Paul, this is a brilliant mod, just whay I have been looking for to backup my 896mb database, this is a must have for large databases

Desibabu19 03-12-2010 04:32 AM

Hi Paul,

Excellent piece. Installed. Thank you very much. I am using VB version 4.0.1.

Created 704 MB backup file.

Processed Database in 182.957 seconds

Backup Completed Successfully
Done

I created one backup file.

I am newbie. I have two questions.

1) If anything goes wrong and if I have to restore the datebase, how do I use this backup file to restore all tables ?

2) As you see it has taken around 3 mins to create backup for website. At any point of time there are about 150-200 users in my site. Is it recommendable to close the forums when the backup runs ? Or is it ok to leave the forums open during the backup ?

mmacrypt 03-24-2010 07:57 PM

Thank you very much. It's nice to have this running when I'm going to be away for a few day.

Quote:

Processed Database in 109.96 seconds

Backup Completed Successfully

Done
Takes some pressure off. I look forward to checking it tomorrow morning and having a backup in place before I even start my day.

Bob_R 03-24-2010 08:13 PM

Quote:

Originally Posted by Paul M (Post 1997323)
You can simply change the date format of the files (in the settings), and make use of the fact that this will replace (delete) any existing file(s) with the same name. On my live site I use the l (lowercase L), which means my files use the day of the week (Monday, Tuesday etc) - so I only ever have 7 backups.

Thanks bro.

Now, for the $64,000 question:

What if something goes wrong? How do you restore the backups?

Thanks!! :)

SoulStealer 03-25-2010 05:46 AM

Code:

Processed Database in 34.312 seconds

Backup Completed Successfully

Done


~thanks :)

wampforum 03-26-2010 09:29 AM

works great even for a complete noob like me - thanks

hydn 03-30-2010 09:04 PM

Will setting path to:
Code:

E:\backup\
work?

I'm on windows server.

thx

hydn 03-30-2010 09:05 PM

Quote:

Originally Posted by Bob_R (Post 2009619)
Thanks bro.

Now, for the $64,000 question:

What if something goes wrong? How do you restore the backups?

Thanks!! :)

x2.

sorry. im really noob when it comes to backups. I usually use the mysql GUI in windows for restore. Does the combined backup file end with *.sql?

aaronrand 03-30-2010 09:36 PM

Processed Database in 7.167 seconds
Backup Completed Successfully
Done

Thanks :)


All times are GMT. The time now is 08:12 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.01913 seconds
  • Memory Usage 1,736KB
  • 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
  • (2)bbcode_code_printable
  • (3)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