vb.org Archive
Page 11 of 12 « First 910 11 12
Show 40 post(s) from this thread on one page

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 (Lite) (https://vborg.vbsupport.ru/showthread.php?t=201319)

Paul M 11-25-2010 08:49 PM
No programming necessary, its in the ACP.

vBulletin Options >> Search Type

ITDarasgah 11-25-2010 10:51 PM
Quote:
Originally Posted by Paul M (Post 2125746)
No programming necessary, its in the ACP.

vBulletin Options >> Search Type
Great..................Thank you very much:up:
now its work like a..:cool:

PHP Code:
Processed Database in 98.067 seconds

[Compressing Combined File] : Processed File Compression in 24.7 seconds

The Backup was completed successfully.

Done 

MjrNuT 11-29-2010 10:40 PM
Hey Paul,

disclaimer: I'm using v.002

I believe since daylight savings time my issue has occurred. I have a backup done 1/week. It will close the forum and then reopen it. But, since daylight savings time, it does not seem to reopen the forum.

Any comment on this?

Thanks

Paul M 11-30-2010 11:26 AM
DST will not make any difference to opening and closing.

As to the option in general - see post #360

MjrNuT 11-30-2010 03:16 PM
Much appreciated.

mp3president 03-13-2011 06:40 AM
I looked at your website, but is it possible for you to give me a link to the pro version?
I'm running a forum with mostly pro versions, after testing the lite versions.

Greetings Ron.

Paul M 03-13-2011 11:41 AM
There is no pro version.

The name "lite" is historical, and not intended to imply there is any other version.

mp3president 03-15-2011 04:51 AM
Thank you Paul, for your quick answer and information.
Shame there is no pro version of it, but i'll do okay with the lite.

Simon Lloyd 03-15-2011 05:24 PM
Quote:
Originally Posted by mp3president (Post 2173504)
Thank you Paul, for your quick answer and information.
Shame there is no pro version of it, but i'll do okay with the lite.
What would you expet in the "pro" version? this does everything you'll need!

Scalemotorcars 03-15-2011 05:46 PM
Im sorry but where the heck are the instructions? :confused::o

Paul M 03-15-2011 08:13 PM
In the zip.

Scalemotorcars 03-15-2011 09:18 PM
Yep, I see those but nothing about the actual settings in the ACP (Control Panel) . Maybe something a little more descriptive for the novice...:o

Quote:
Installation.

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

2. Upload the product XML via the Product Manager.

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

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

Note: There are some advanced options available in the uploaded config file.

Paul M 03-16-2011 11:44 AM
As I recall they are pretty self explanatory, and generally dont need to be changed. What option are you referring to ?

Scalemotorcars 03-16-2011 01:49 PM
Files Prefix = Forum- ??? My site uses another forum prefix. Not the default vb3. Do I change this to my database prefix?

Backups Path = ../../backups/ Do I create this Dir or will the program do it? Should it be 644 ~ 777? Relative path ??? Not exactly sure what a relative path is. Ill know- Google it.

InnoDB Tables ??? No ideal if I have them or not. How would I make sure?

Thanks Paul for your time. I just want to make sure 100% its done correctly and it doesn't hurt having the info here for others to use. :D

Simon Lloyd 03-16-2011 06:17 PM
Quote:
Originally Posted by Scalemotorcars (Post 2173999)
Files Prefix = Forum- ??? My site uses another forum prefix. Not the default vb3. Do I change this to my database prefix?
This is simply how you want the file identified after its created so you could call it "my really long name for back up" and it will appear as "my really long name for back up - MyForum.Sql.zip"....etc

Quote:
Originally Posted by Scalemotorcars (Post 2173999)
Backups Path = ../../backups/ Do I create this Dir or will the program do it? Should it be 644 ~ 777? Relative path ??? Not exactly sure what a relative path is. Ill know- Google it.
the example shown here is for a folder called backups and will be above public_html level (i.e the folder that houses public_html) but you can have the folder wherever you want and change the path, and yes the folder should b CHMOD 777 which again is why it should be at /home level rather than /public_html level

Quote:
Originally Posted by Scalemotorcars (Post 2173999)
InnoDB Tables ??? No ideal if I have them or not. How would I make sure?

Thanks Paul for your time. I just want to make sure 100% its done correctly and it doesn't hurt having the info here for others to use. :D
Ignore Innodb, if you have not specifically changed these tables in phpmyadmin or via ssh then they will be MYISAM by default.

Paul M 03-16-2011 09:14 PM
Well, that pretty much covers it - thank you Simon. :D

Scalemotorcars 03-17-2011 12:34 PM
Thanks guys I really appreciate it.:up:

Simon Lloyd 03-17-2011 06:14 PM
Quote:
Originally Posted by Paul M (Post 2174151)
Well, that pretty much covers it - thank you Simon. :D
You're welcome :), i remember when i was scared to change or touch anything on my server or in VB, but now that i have broken it and fixed it so many times i like to help those who fear it get in the same mess :D

mp3president 03-18-2011 04:56 AM
Quote:
Originally Posted by Simon Lloyd (Post 2173678)
What would you expet in the "pro" version? this does everything you'll need!
Maybee it had some extra functions in it, like always in pro versions.
But i'm not complaining about this plugin, it works perfectly, thank you.

XFSImperial 03-18-2011 07:24 PM
Works perfectly and the gzip feature really helps increase the number of past backups I can keep on the server.

Dingo14 05-10-2011 03:20 AM
could this be done for version 3.7 thanks

HMBeaty 05-10-2011 03:22 AM
Quote:
Originally Posted by Dingo14 (Post 2193888)
could this be done for version 3.7 thanks
https://vborg.vbsupport.ru/showthread.php?t=167276

Dingo14 05-10-2011 04:49 AM
Quote:
Originally Posted by HMBeaty (Post 2193889)
thanks for reply nice one

Vcize 08-05-2011 07:10 PM
When I attempt to run it I just get the following error:

Quote:
An error occured during the Backup :
With no message..

Paul M 08-06-2011 12:27 AM
Not much i can tell you with no message, other than its likely a server issue.

Simon Lloyd 08-06-2011 04:54 AM
It's almost certainly down to your timeout on the server or your settings for PHP memory or MySql packets....etc

newguy 08-06-2011 08:25 PM
Quote:
Originally Posted by Vcize (Post 2229810)
When I attempt to run it I just get the following error:



With no message..
That happened to me until I got my directory correct where it was supposed to put the backup.

Lets say you forum root is forums and you dump your back up in forums/folderx what i did is enter in folderx/ in the backup path and it works and make sure foderx has 777 permissions. I also did password protect that directory also. Not sure if 777 permissions is the one to use though???

Simon Lloyd 08-07-2011 07:17 AM
Having your folder at public level is not a good idea as explained by PaulM in his mod, your folder should be at least one level up, that way there is no need to password protect it or worry about folk accessing your entire database details. PaulM has already provided a path, simply put your backup folder there.

newguy 08-07-2011 10:18 AM
Quote:
Originally Posted by Simon Lloyd (Post 2230421)
Having your folder at public level is not a good idea as explained by PaulM in his mod, your folder should be at least one level up, that way there is no need to password protect it or worry about folk accessing your entire database details. PaulM has already provided a path, simply put your backup folder there.
I am sorry I did change mine to one level above the public_htlm. That is good right?

Simon Lloyd 08-07-2011 05:03 PM
Quote:
Originally Posted by newguy (Post 2230454)
I am sorry I did change mine to one level above the public_htlm. That is good right?
;) yep thats right!

crouzmind 08-08-2011 03:53 PM
sir can you assist me about this error .

An error occured during the Backup :

i have vbulletin 3.8 and i did not know how can i edit my config file please tell me where i need to put the full path of the folder where i want to put the backup dump .

thanks in advanced .

Simon Lloyd 08-08-2011 04:54 PM
Quote:
Originally Posted by crouzmind (Post 2230941)
sir can you assist me about this error .

An error occured during the Backup :

i have vbulletin 3.8 and i did not know how can i edit my config file please tell me where i need to put the full path of the folder where i want to put the backup dump .

thanks in advanced .
If you read the text that came with the mod and look at the mod settings you will see where Paul M has already set the folder path you simply need to use this (make sure a folder of that name appears in that location as the mod doesn't create one) or change the folder name and location to yours.

Vcize 08-08-2011 06:02 PM
Quote:
Originally Posted by Simon Lloyd (Post 2230421)
Having your folder at public level is not a good idea as explained by PaulM in his mod, your folder should be at least one level up, that way there is no need to password protect it or worry about folk accessing your entire database details. PaulM has already provided a path, simply put your backup folder there.
Perhaps that is my problem. I use dreamhost, so there is no public_html folder or anything like that.

When I log into the root of my server, I just see a folder for each of my sites. Inside each of those folders are the sites files.

So, I created my backup folder in the root, so now the root of my server looks like.

site1.com
site2.com
site3.com
site4.com
backups

Is that right?

Simon Lloyd 08-08-2011 06:05 PM
It should be, if you use a file manager, when you click on the folder or check it's properties what does it show?

Vcize 08-08-2011 07:28 PM
Quote:
Originally Posted by Simon Lloyd (Post 2230980)
It should be, if you use a file manager, when you click on the folder or check it's properties what does it show?
I'm using filezilla.

Don't see an option for properties. That permissions are 777.

Fynnon 10-23-2011 08:47 PM
i get an errorr:

Code:
Database error in vBulletin 3.8.6:

Invalid SQL:

                        INSERT INTO cronlog
                                (varname, dateline, description, type)
                        VALUES
                                ('cbu_crontask',
                                1319406226,
                                'An error occured during the Backup : ',
                                0);

MySQL Error  : Table 'cronlog' was locked with a READ lock and can't be updated
Error Number  : 1099
Request Date  : Sunday, October 23rd 2011 @ 11:43:46 PM
Error Date    : Sunday, October 23rd 2011 @ 11:43:46 PM
Script        : http://www.xxx.com/admincp/cronadmin.php?do=runcron&cronid=45
Referrer      : http://www.xxx.com/admincp/cronadmin.php?do=modify
IP Address    : xx.xx.xx.xxx
Username      : xxx
Classname    : vB_Database
MySQL Version : 5.0.77

Walter Ronny 07-27-2012 06:59 PM
there is a version working for 4.2?

Thanks!

Paul M 07-27-2012 08:51 PM
Yes.

Just click on my title (Dr Pepper ..) and it will take you to the modification list in my profile.

trotskid 03-11-2013 09:51 AM
Hi. It would be possible rewrite the backup file to avoid having to delete every day the accumulate files in the database?

Thanks

valdet 01-13-2015 08:32 AM
Paul,
Is there an easy way to clone the mod, so besides taking daily SQL backups, we can also set a cron job so it takes a monthly backup?

I currently have the Date Format field as d which makes backups in date based directories.

However I'd like to know if it's possible to have another cronjob set up so it takes the monthly backups (e.g. on day 1 of each month) and the Date Format would be M

Quote:
M A short textual representation of a month, three letters Jan through Dec
Thanks for excellent mod.


All times are GMT. The time now is 05:53 AM.
Page 11 of 12 « First 910 11 12
Show 40 post(s) from this thread on one page

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.01668 seconds
  • Memory Usage 1,830KB
  • 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
  • (1)bbcode_php_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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