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

Paul M 05-18-2008 05:38 PM

Quote:

Originally Posted by b6gm6n (Post 1523627)
ahh right thanks, thats 'backups' within public html? - well ok then :)

Its just an example, not a suggestion of what to actually use.

XFSImperial 05-19-2008 12:44 AM

Installed. We'll see how things go tonight at 1:00AM :)

b6gm6n 05-19-2008 05:02 PM

well i waited a day...only ran the once (by me pressing run-now) for some reason it's not working, i have lost confidence, uninstalled, sorry dude

Paul M 05-19-2008 05:54 PM

Works fine if you set it up correctly, not much i can do if you dont. :)

b6gm6n 05-19-2008 07:07 PM

Quote:

Originally Posted by Paul M (Post 1524958)
Works fine if you set it up correctly, not much i can do if you dont. :)

yeah your right, i know.... i just got frustrated with it as other things were praying on my mind, re: other webbby stuff not installing...or driving me mad :)

energetic 05-25-2008 12:14 AM

installed and thanks
please tell how to restore the database if needed ?

Chadi 05-25-2008 06:41 PM

Quote:

Originally Posted by Paul M (Post 1518836)
It does not delete backups (unless they are the same name as the new one its creating, in which case it will overwrite).

Could you possibly add this feature to automatically prune backups older than x amount of days? That would be great.

Paul M 05-25-2008 07:04 PM

Sorry, I wont be adding any features to this in the forseeable future.

Jason Buchanan 05-31-2008 05:33 PM

I am a true rookie when it comes to this. Does it matter which folder on the server I upload the files too, or do they go in the forum folder?

Paul M 06-01-2008 05:11 PM

Copy the files in the includes folder to your forum includes folder, similar for the cron folder.

Jason Buchanan 06-01-2008 11:12 PM

Okay I have installed everything in the proper folders. I click run and get:
Automatic Database Backup for vBulletin 3.7

An error occured during the Backup : Could not open Destination SQL file for writing.

I created a folder named backups? What else should I do and how do I CHMod a folder to 777?

Jason Buchanan 06-01-2008 11:30 PM

I changed all the 0666 to 0777 and now when I run it I get this:

Automatic Database Backup for vBulletin 3.7

Warning: require_once([path]/includes/mysqlbackup.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/cron/cronbackup.php on line 19

Fatal error: require_once() [function.require]: Failed opening required '/home/darkhors/public_html/forum/includes/mysqlbackup.php' (include_path='.:/usr/local/php52/pear') in /home/darkhors/public_html/forum/includes/cron/cronbackup.php on line 19

TrIn@dOr 06-02-2008 02:23 AM

Thanks.

shlomot 06-02-2008 03:04 AM

Thanks for this important MOD. However, I'm getting the same error:
Quote:

Originally Posted by nothing4me (Post 1506066)
I get the error: An error occured during the Backup : Could not open Destination SQL file for writing.

The situation is as follows:

1. I didn't edit anything in mysqlbackupconfig.php

2. Since the relative path for the backup files is '../../backups/', I created a 'backups' folder in forum root and chmod to '777'

What am I missing here? Thanks for your help.

|Jordan| 06-02-2008 05:05 AM

Is there any way to have it automatically compress the backed up database? The backup can be quite large.

russbo 06-02-2008 05:15 AM

try ./backups/ if your backup folder is in the forum root, or, ../forum/backups/

I had to play with mine for a bit. You guys get this error when the config file can't find the backups folder.

I put mine outside the forum root, and outside the public html root so that it's more protected. use the actual server path to the folder if you want to do it that way.

Paul M 06-02-2008 06:52 AM

Quote:

Originally Posted by shlomot (Post 1538336)
What am I missing here? Thanks for your help.

Probably open_basdir protection.

Quote:

Originally Posted by |Jordan| (Post 1538380)
Is there any way to have it automatically compress the backed up database? The backup can be quite large.

Nope, this has no such facility.

shlomot 06-02-2008 07:40 AM

Quote:

Originally Posted by Paul M (Post 1538443)
Probably open_basdir protection.

How can I overcome this challenge?

Paul M 06-02-2008 08:02 AM

Read this, and speak to your host.

shlomot 06-02-2008 08:55 AM

Thank you. Will do.

Quote:

Originally Posted by Paul M (Post 1538485)
Read this, and speak to your host.


SaPh[i]R 06-09-2008 10:49 AM

Can we configure the hack to save database in another FTP Please ?

Paul M 06-09-2008 11:39 AM

Nope, you cannot do that with this mod.

chet 06-09-2008 01:33 PM

Nice one, Installed

LCN2007 06-14-2008 02:55 PM

Im a little lost i wanted to use this great hack when i was 3.6 but got the same error.

Automatic Database Backup for vBulletin 3.7

An error occured during the Backup : Could not open Destination SQL file for writing.

can someone help me?

LCN2007 06-16-2008 10:15 PM

Can Anyone help?

Paul M 06-16-2008 10:18 PM

If you read the thread you will see that this is down to permissions on your server, there is not much we can do as you havent really given any information.

Artes_Marciales 06-17-2008 07:13 AM

Thanks Paul, Great mod.
does she work if the data base is very heavy? (around 1GB)

Best Regards!

Paul M 06-17-2008 07:19 AM

Yes, should be fine.

Artes_Marciales 06-17-2008 07:23 AM

Thanks for reply!! : )
**installed**

69lakalle 06-17-2008 08:20 AM

I get this error: and my forum stays with the error and the backup wont complete i cant even access admincp....but when reparing tables everything go back to normal, but i can never do backup, i get that error, before it was all good now idk what happen it wont work


Quote:

Database error in vBulletin 3.7.0:

Invalid SQL:
CHECK TABLE `post_thanks`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, June 17th 2008 @ 04:11:16 AM
Error Date : Tuesday, June 17th 2008 @ 04:12:07 AM
Script : http://www.xxxx/forums/admincp/crona...cron&cronid=27
Referrer : http://www.xxxx/forums/admincp/cronadmin.php?do=modify
IP Address : xxxxxxxx
Username : xxxxxx
Classname : vB_Database
MySQL Version :

Paul M 06-17-2008 10:29 AM

You mysql timeout must be very low - I would say the database connection is timing out checking the previous table, which I would guess is the post table.

Sakai Ray 06-17-2008 04:49 PM

This is great clicks install.

PGAmerica 06-17-2008 05:04 PM

This mod rocks, I am having 2 problems.

1) Whenever I modify my "mysqlbackupconfig.php" file to exclude tables from the backup, I get an error that says
Code:

Parse error:  parse error, unexpected ',', expecting ']' in mysqlbackupconfig.php on line 29
Line 29 is where I put in my exclusions. The currently say
Code:

  $backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables
  $backup['quiz_questions','quiz_answers']    = array(); // Table List - e.g. array('table1', 'table2')

They are large and never change so I do not want them backup up. There is nothing wrong with the way they are entered into the array. What is wrong here?

2) The scheduled task area does not have an option to make a task run every 3rd day. How do I do this? This is not a busy site, I have no need for a daily backup.

Ideas?

Paul M 06-17-2008 05:56 PM

1. The example clearly shows you put the tables in the array, you have not done this.

Code:

$backup['TABLES'] = array('quiz_questions','quiz_answers');

2. You cannot do this with the vb cron system.

PGAmerica 06-17-2008 06:04 PM

Quote:

Originally Posted by Paul M (Post 1551862)
1. The example clearly shows you put the tables in the array, you have not done this.

D'Oh! I am such an idiot! Thanks
Quote:

Originally Posted by Paul M (Post 1551862)
2. You cannot do this with the vb cron system.

Is there mod out there that allows me another choice for cron execution?

69lakalle 06-19-2008 03:11 AM

Quote:

Originally Posted by Paul M (Post 1551513)
You mysql timeout must be very low - I would say the database connection is timing out checking the previous table, which I would guess is the post table.

Thank You
What should i do?
Contact webhost ?
What is a good timeout for mysql ?
Thank You again

Paul M 06-19-2008 04:29 PM

If you are on a shared server then contact your host - dont hold out too much hope tho.

BeerLuver 06-20-2008 05:49 AM

Excellent mod/addon :). I'm not too savvy with setting up cronjobs/scheduled tasks properly, so this worked perfectly. Saves a lot of time and hassle for doing regular backups; which I often tend to forget to do heh.

So huge thanks for this :up:

Paul M 06-20-2008 06:39 AM

Quote:

Originally Posted by PGAmerica (Post 1551865)
Is there mod out there that allows me another choice for cron execution?

None I know of.

Artes_Marciales 06-23-2008 05:18 AM

There is any way that files not contain in your name the date but the folder yes contain?
Best Regards!!

**nominated**


All times are GMT. The time now is 08:39 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.01460 seconds
  • Memory Usage 1,818KB
  • 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_code_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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