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)

Gary_Oak 12-08-2012 04:00 PM

Quote:

Originally Posted by djbaxter (Post 2389335)
In Settings, make sure the folder is specified as follows (assuming it is also in public_html):

Code:

AutoBackups/
Note: this is case sensitive.

The cron job should have been added automatically when you installed this add-on.

varname: cbu_crontask
Title: Automatic Database Backup for vBulletin
Filename: ./includes/cron/cronbackup.php
Product: Automatic Database Backup

Whoops, I had it outside of public_html as its own file folder. Fixed that.

I also had /AutoBackups instead, because it was outside public_html, but I fixed that as well. And yeah, I figured as much that it is case sensitive.

Yes it was automatically added. I had that at first, but then I changed it back to /includes/cron, so I went ahead and changed it back again to ./includes/cron/cronbackup.php right now.

And it worked! I hit Run Now, and so it backed up my Database in 10.605 seconds. And I checked my AutoBackups folder, and the backup is in there! So I got it all working now, thanks so much for your help! :D

Just one last question. Because I am kinda new to vBulletin and all, once I have the database file on my computer, how do I do a restore with it so I can test it to make sure it's not corrupted and all or if I actually do need to do a restore for some reason?

djbaxter 12-08-2012 04:17 PM

Quote:

Originally Posted by Gary_Oak (Post 2389340)
And it worked! I hit Run Now, and so it backed up my Database in 10.605 seconds. And I checked my AutoBackups folder, and the backup is in there! So I got it all working now, thanks so much for your help! :D

Glad to hear it's working now.

Two more hints:

1. Combine Files = Yes
2. Block Processing = Yes
3. If you have Gzip enabled on your server (most do), I'd recommend GZip Files = Yes

This will make smaller files.

Remember! Old backup files once created are NOT deleted. You need to go into your site via FTP or SSH and delete old backups periodically or you'll eventually fill up the disk.

Quote:

Originally Posted by Gary_Oak (Post 2389340)
Just one last question. Because I am kinda new to vBulletin and all, once I have the database file on my computer, how do I do a restore with it so I can test it to make sure it's not corrupted and all or if I actually do need to do a restore for some reason?

  1. Create a NEW EMPTY database - because you don't want to overwrite your actual forum database with old data.
  2. Using FTP, download one of the backups to your home computer.
  3. Go into phpMyAdmin and click on Import and follow instructions there.

smirkley 12-08-2012 04:20 PM

Rereading the last few pages it seems we have a common theme here.

The manual run of the cron produces expected output where you expect them in your settings.

But the automatic cron trigger produces in cron logs "Automatic Database Backup for vBulletin - Backup Completed Successfully" yet succesful doesnt mean any file shows up where it should. Tested on multiple times settings.

Running on : vb 4.2.0 Patch Level 3

Gary_Oak 12-08-2012 04:28 PM

Quote:

Originally Posted by djbaxter (Post 2389343)
Glad to hear it's working now.

Two more hints:

1. Combine Files = Yes
2. Block Processing = Yes
3. If you have Gzip enabled on your server (most do), I'd recommend GZip Files = Yes

This will make smaller files.

Remember! Old backup files once created are NOT deleted. You need to go into your site via FTP or SSH and delete old backups periodically or you'll eventually fill up the disk.

As am I, I've always loved the vBulletin backup system but I'm not that skilled when it comes to this kind of stuff yet.

I had already done all of those except the Gzip one because I wasn't sure if it would work and I wasn't sure I would need it, but yeah I'll go ahead and set it Yes as well.

I realized that as I was studying up on how vBulletin works some months ago and then as I was deleting some things off my server the past few days. I thought my host gave me unlimited disc space, but what use would I have for extremely old backups anyway? Thanks!

Quote:

Originally Posted by djbaxter (Post 2389343)
  1. Create a NEW EMPTY database - because you don't want to overwrite your actual forum database with old data.
  2. Using FTP, download one of the backups to your home computer.
  3. Go into phpMyAdmin and click on Import and follow instructions there.

Okay I will try that out, thank you again! To create a new empty database, you go into the cPanel and into MySQL Databases and just create a new database and/or assign a user to it, correct?

Edit;

Quote:

Originally Posted by smirkley (Post 2389346)
Rereading the last few pages it seems we have a common theme here.

The manual run of the cron produces expected output where you expect them in your settings.

But the automatic cron trigger produces in cron logs "Automatic Database Backup for vBulletin - Backup Completed Successfully" yet succesful doesnt mean any file shows up where it should. Tested on multiple times settings.

Running on : vb 4.2.0 Patch Level 3

I haven't tested the automatic backup yet, as I have it set to 5:30 PM my time and it's 11:30 AM my time right now. I'll check it this evening though, and get back to you as to whether or not it is working for me. I have vB 4.2.0 Patch Level 2, now I can upgrade because I can backup my database. Lol

smirkley 12-08-2012 05:17 PM

Thanks, looking forward to your test results Gary...

fyi, I set my cron this morning to run every hour until I get the auto thing to work, and the cron is running and logging successful every hour so far, but no cigar in my backup folder at all for todays date.

djbaxter 12-08-2012 05:24 PM

Quote:

Originally Posted by smirkley (Post 2389360)
Thanks, looking forward to your test results Gary...

fyi, I set my cron this morning to run every hour until I get the auto thing to work, and the cron is running and logging successful every hour so far, but no cigar in my backup folder at all for todays date.

Where is the backup folder? Are you sure vBulletin has permission to access it? If it's not accessible from the forum root, your server configuration may not allow it, regardless of the permissions.

smirkley 12-08-2012 05:27 PM

Located in root in non public area.

Thing is the cron works and writes the file if I run it manually, so I know the cron manually triggered will cause vb to write in this directory.

Is that correct thinking?...if it can write on a manual run, it should also to be able to write on a scheduled run?

djbaxter 12-08-2012 05:35 PM

Quote:

Originally Posted by smirkley (Post 2389363)
Located in root in non public area.

Thing is the cron works and writes the file if I run it manually, so I know the cron manually triggered will cause vb to write in this directory.

Is that correct thinking?...if it can write on a manual run, it should also to be able to write on a scheduled run?

I'm not sure that's universally true. If it won't run manually, it almost certainly won't run automatically but the reverse may not hold.

Do you know if your server is running under suPHP or Safe Mode or with open_basedir restrictions enabled, or something similar?

smirkley 12-08-2012 05:49 PM

No restrictions on my VPS, in fact I have full control, but definetly is not in safe mode.

Just verified my php and "open_basedir" has "no value" installed. "No Value"=no restrictions?

Isnt the only difference between a manual and an automatic cron run, the point of the trigger?

djbaxter 12-08-2012 05:59 PM

Quote:

Originally Posted by smirkley (Post 2389366)
No restrictions on my VPS, in fact I have full control, but definetly is not in safe mode.

How is PHP configured though?


Quote:

Originally Posted by smirkley (Post 2389366)
Just verified my php and "open_basedir" has "no value" installed. "No Value"=no restrictions?

I would assume so.

Quote:

Originally Posted by smirkley (Post 2389366)
Isnt the only difference between a manual and an automatic cron run, the point of the trigger?

Honestly not certain. But I know on some forums where I've installed this I have encountered the situation where manual will work and auto will fail and it usually had to do with either permissions or folder outside the forum root.


All times are GMT. The time now is 10: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.02152 seconds
  • Memory Usage 1,762KB
  • 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
  • (11)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