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 - Automatic Database Back-up (https://vborg.vbsupport.ru/showthread.php?t=114097)

Logikos 04-25-2006 10:00 PM

Automatic Database Back-up
 
Automatic Database Back-up



Keywords
Automatic, Database, Backup, Cron

What this does
This is a port of Brad's hack that can be found here. This will backup your database using the vBCron system in vBulletin and send the file to a directory that you specified in the vBulletin Options area.


IMPORTANT NOTE TO ALL THAT USE THIS SCRIPT
This script invokes an outside process that runs in the backround on your server to backup and compress your database. It is important to remember that this is not an instant process, do not enter you ftp as soon as the script says it is done and try to download your backup. It will likely be incomplete and your server will probbly still be writting the file to disk.

I ussally give the process an hour or two before I mess with the file, larger databases will take more time of course.

To do list...
  • Time to install: 5 minutes
  • Queries to run: 0
  • File Mods: 0
  • Templates to edit: 0
  • Templates to add: 0
  • New Phrases: 5
  • New Plugins: 0

Credits
Thanks to Brad for allowing me to port this.

Install This Product
Show your support and click the install button!

Testing Information
I've been using this for vBHackers.com since I first upgrade. I have all my backups being sent to a directory, outside of the public_html. I've yet to experiance any problems. I have had to use one of the backups before, and all worked well.

Product History
Wednesday, April 26, 2006 - Public Released

Help & Support
Before asking for support, please make sure you have done all the necessary changes! If you still need support, please post a reply here and double check that you have clicked the Install Button. I will try to support this hack the best I can. Support is not guaranteed!

Please post any bugs and errors here. Hope you like it, feedback is always welcomed! :)

Logikos 04-26-2006 08:31 AM

~ Post Reserved ~

Frapegliko 04-26-2006 08:36 AM

cool mod

apdcanari 04-26-2006 08:57 AM

Cool..but I have an error :

Automatic Database Back-up

Warning: exec() has been disabled for security reasons in /includes/cron/databack.php on line 21

Fait

Atakan KOC 04-26-2006 08:58 AM

Thanks LiveWire

Logikos 04-26-2006 09:02 AM

@ apdcanari: Your host has disabled that feature for security reasons. I suggest you contact your host. :)

@ Atakan KOC & Frapegliko: Thanks & No Problem! :)

apdcanari 04-26-2006 09:07 AM

Quote:

Originally Posted by LiveWire
@ apdcanari: Your host has disabled that feature for security reasons. I suggest you contact your host.

Ok, thanks.

My host is Informaniak

theArchitect 04-26-2006 11:55 AM

Forgive the nOObie question, but does this work using the same system as a SSH autobackup?

I have set-up a script, with a friends help on my server which takes care of my back-ups, but this hack could be useful for other site I work on where I don't have SSH access and can't set-up something similar to my system.

But I am very nervous of the AdminCP back-up system.

dacho 04-26-2006 01:11 PM

installed but there is a error problem
Code:

Warning: exec(): Unable to fork [mysqldump --add-drop-table -h192.000.000.000 -uXXXXX -XXXXX XXXXX 2>/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006-error.txt >/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006.sql] in \includes\cron\databack.php on line 21

Warning: exec(): Unable to fork [tar -cSz --remove-files -C/XXXX/XXXX/forums.dacho.co.il/XXXX -f/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006.tar.gz 04-26-2006.sql 04-26-2006-error.txt] in \includes\cron\databack.php on line 26


COBRAws 04-26-2006 02:49 PM

Quote:

Originally Posted by dacho
installed but there is a error problem
Code:

Warning: exec(): Unable to fork [mysqldump --add-drop-table -h192.000.000.000 -uXXXXX -XXXXX XXXXX 2>/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006-error.txt >/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006.sql] in \includes\cron\databack.php on line 21

Warning: exec(): Unable to fork [tar -cSz --remove-files -C/XXXX/XXXX/forums.dacho.co.il/XXXX -f/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006.tar.gz 04-26-2006.sql 04-26-2006-error.txt] in \includes\cron\databack.php on line 26


The dir path to your forums is -C/XXXX/XXXX/forums.dacho.co.il/XXXX ??


I think it is -C/XXXX/XXXX/dacho.co.il/XXXX/forums


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

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.01365 seconds
  • Memory Usage 1,739KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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