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)

Deuces73 03-12-2013 09:46 PM

Overlooked the " 1 file " setting , as i read that default settings where the way to go and assumed that 1 file would be default.

So if anyone encounters a simular problem , try setting :

Code:

Set to yes to combine all tables into one backup file.
to " Yes " as it appears to be on no by default.

Result :


Processed Database in 50.898 seconds

Backup Completed Successfully
Done


;)

Bengie 03-23-2013 04:09 PM

Quote:

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.
Well that's me lost already, sorry but I haven't a clue what this means.

I haven't seen it mentioned, does this do a recovery as well ?

smirkley 03-23-2013 07:18 PM

If you mean a database recovery, this mechanism just creates the backup files.

For me, I would do a recovery via phpMyAdmin in my server control panel, using the backup file I selected.

JfoxEdge 03-26-2013 12:54 AM

Having a problem. VB 4.1.12. No idea where to look. When I try to run a backup by clicking Run Now from the Scheduled Task Manager, I immediately get a message that says:

Automatic Database Backup for vBulletin
Backup Aborted : vBulletin Options Error

Any help would be appreciated.

Thanks!

Paul M 03-26-2013 05:31 PM

Are you using some form of datastore cache ?

Basically that means the code failed to load your options.

Sios 03-28-2013 04:59 AM

I'm new altogether to this "cron job" and don't understand how to run the backup.

I already have the Mod marked as Installed as well as the mod installed through my FTP.

So my questions are:

- What do I do from here?

- How do I access this "cron jobs" and set it up?

- How do I make it automated to run per week basis?

Paul M 03-29-2013 01:52 AM

Do you install the product as well ? That create the cron job for you.

flash84 03-29-2013 02:12 AM

Quote:

Originally Posted by Sios (Post 2412640)
I'm new altogether to this "cron job" and don't understand how to run the backup.

I already have the Mod marked as Installed as well as the mod installed through my FTP.

So my questions are:

- What do I do from here?

- How do I access this "cron jobs" and set it up?

- How do I make it automated to run per week basis?


For the settings go to:
AdminCP > Options > vBulletin Automatic Backup

For the cron job schedule go to:
AdminCP > Scheduled Task Manager > Automatic Database Backup for vBulletin

smirkley 03-29-2013 02:25 AM

Quote:

Originally Posted by Sios (Post 2412640)
I'm new altogether to this "cron job" and don't understand how to run the backup.

I already have the Mod marked as Installed as well as the mod installed through my FTP.

So my questions are:

- What do I do from here?

- How do I access this "cron jobs" and set it up?

- How do I make it automated to run per week basis?

And I know this thread has 56 pages so far, but trust me from experience, most questions you could ask are in here somewhere.

It took me about two times reading all the pages to figure it out.

I'm kinda slow sometimes. :o

flash84 04-28-2013 03:36 AM

Just tried this on a larger database and though I had timeout issues but it turns out that the database backup file gets too large for the file system and the server kills the script.

This is an issue which could be affecting people with large databases. If the backup file gets to 2Gigabytes (2,147,483,648 Bytes) it will stop creating the file and you will see "child pid xxxxx exit signal File size limit exceeded (25)" in the server error log. The backup file will be stuck at 2,147,483,647 Bytes.

This is because linux can only create files up to 2GB on a 32bit operating system.

To get around this just change the "Combine Files" setting to "No" and each table will be backed up individually. So long as an individual table is no large than 2GB it will work :)


All times are GMT. The time now is 12:02 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.02084 seconds
  • Memory Usage 1,746KB
  • 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_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