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)

patracy 01-27-2016 04:34 PM

Quote:

Originally Posted by Dave (Post 2563486)
To be honest if your database is reaching a point where it's getting quite big, you should not rely on such plugin anymore but create your own OS based cronjob. In Linux you can make use of crontabs and create a basic bash script that executes the mysqlbackup command.

That's true. And actually that's the direction I've been meaning to go in. But I've not been able to find a method on scheduling vB on/off. I suppose I could cron apache on and off, but that'd leave users in the dark.

shimei 01-27-2016 06:16 PM

Quote:

Originally Posted by patracy (Post 2563581)
That's true. And actually that's the direction I've been meaning to go in. But I've not been able to find a method on scheduling vB on/off. I suppose I could cron apache on and off, but that'd leave users in the dark.

I began a thread here on the subject: Maintenance Page for Cron Backup

Davidinh 03-17-2016 03:44 PM

seem something were missing in the Auto-backup.txt and base on my problem I would like to share to all

Installation
------------

1. Copy all files in the 'includes' folder to the server.

2. Upload the product XML via the Product Manager.

3. Set your choice of options in the ACP (vBulletin Options).

4. Alter the timing of the cron job to suit.

5. To use the (experimental) MySQL backup option, you need to edit the mysqlbackup.php file.

Find var $DTYPE = 'php'; and change it to var $DTYPE = 'mysql'

In a case for new version of mysql you should add var $MYSQLI; (after var $MYSQL) in mysqlbackup.php then change var $DTYPE = 'mysqli' ;

6. Create the new folder as "backups" or what ever you desire for it then set permission as 777

if it is in the root website in AdminCP option should set ./backups/
if it is in the forum directory in AdminCP option should set ../backups/

and so on.

hope it helps

THANK YOU PAUL it is useful mode

Paul M 03-17-2016 10:18 PM

Quote:

Originally Posted by Davidinh (Post 2567457)
In a case for new version of mysql you should add var $MYSQLI; (after var $MYSQL) in mysqlbackup.php then change var $DTYPE = 'mysqli' ;

This isnt necessary, and wont do anything.
In fact, if you set $DTYPE = 'mysqli' you will end up using the php backup process.
You seem to be confusing variable names with actual database systems, the fact you are now using MySQLi doesnt affect the variable names.

For the backup path, you should never use a website location (i.e. one thats accessible via a url) such as the two examples you gave, otherwise anyone can potentially just download your backup files.

twlMavRic 03-18-2016 04:07 AM

Installed and ran backup in just over 11 secs. Works as advertised

Manoel J?nior 03-19-2016 02:41 PM

Advise not to use this product if you have a forum that goes from 1GB database, I recommend you look for something like mysqldump

charlesr 03-20-2016 11:05 AM

Any particular reason? Mine is 3.5GB and it works ok. It compresses to a 600MB .gz
I haven't tried restoring it for a while, but it worked a while back ok.

Idawg 03-01-2017 11:20 PM

I have used this mod for years, on many forums I set up/run for clients..

On my newest forum, I am on 4.2.3 and I uploaded to correct location, set everything under options and when I go to save, it gives me a 404 error????? What is up with that ??

RichieBoy67 03-01-2017 11:21 PM

File permissions set to 777?

Idawg 03-01-2017 11:29 PM

On what???


All times are GMT. The time now is 08:37 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.03321 seconds
  • Memory Usage 1,740KB
  • 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
  • (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