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

Kamern 09-11-2009 03:03 PM

I'm getting the same error as a previous poster, it isn't giving me a reason for an error, but it isn't backing up. Fresh install, by the way.

I fixed the problem by using "././backups/" instead of "../../backups/"

MrDeath 09-12-2009 04:14 AM

Quote:

Originally Posted by VedicJunction (Post 1878329)
that i already did... let me explain it more clearly...

my backup folder is /home/xxxx/forum_backup/

now inside that forum_backup folder i have several folders
forum_backup/2009-08-31/Form-2009-08-31-full-backup.sql
forum_backup/2009-09-01/Form-2009-09-01-full-backup.sql
forum_backup/2009-09-02/Form-2009-09-02-full-backup.sql

so you can see that every day a new folder is created of that particular date... Creating new folder for each backup make sense when you are NOT using combined files...

so what i want is the all the backup files should go into the forum_backup folder and do not create separate folder for each date..

thanks!!

Hi Paul!,, since i cannot wait for the next version of the mod, i tried to patch the mod with this option... :).... i thought of uploading my modifications so that other ppl can benefit.. hope you dont mind...

i have added two options :

IF you choose to "COMBINE FILES" Then:-

1. All the backups now goes into a single backup dir.
2. If on Linux... then you also have a option to produce a compressed .gz file.

Installation :

1. install the original mod.
2. replace mysqlbackup.php with the attached one.
3. Uninstall the product.
4. Re-import the product with the attached xml file.

Important info..
1. the relative path do not work for me... i used full path (/home/sdadsf/backup/)
2. Do not use this if you do not want to combine your files..
3. I am not a php programmer .. so use it at your own risk.!!

Paul M 09-12-2009 09:06 AM

Actually, Ive already fixed it locally to put combined files in the root folder, just not released it atm. I might look at the compress feature as well, since a number of requests have been made for it.

creative-friend 09-14-2009 07:04 PM

So This will defo do my mysql backup??

Paul M 09-14-2009 08:09 PM

Thats a somewhat vague question, can you be more specific please.

creative-friend 09-15-2009 09:17 PM

can you please tell me....how am i gonna find out that my data base has been backuped??

i dont have idea how to use this Mod...please help me...

EidolonAH 09-16-2009 11:51 AM

I so often forget to back-up each day, this is a fantastic mod, thank you very much for this.

mcyates 09-16-2009 06:19 PM

How long does this take, i clicked run now from the shedule menu and its been running for 10 min, can't access the forum either because of a database error which I don't know what it is. My database is only 330meg in size.

I put it to lock the forum, repair and close the forum. Surely I shouldn't be getting a database error?

Paul M 09-16-2009 06:39 PM

To backup 330M shouldnt take more than a minute or two.

I cant comment on any database error unless you post the actual error.

mcyates 09-16-2009 07:18 PM

the server was playing up, but i can't seem to get the file location correct. Think i'm being stupid.

Paul M 09-16-2009 10:27 PM

Not much a can say to that :)

Joe2288 09-17-2009 04:40 PM

I'm also getting the error

An error occured during the Backup :

My backup path is ././backups/ and it does create folders with the current date when I manually start the process but nothing else.

Any ideas?

Paul M 09-17-2009 04:56 PM

././backups/ should really be ./backups/

You need to check folder permissions.

Joe2288 09-17-2009 05:07 PM

I have folder permission set at 777 and as I mentioned it does create subfolders with the current date so I think the permission is set correctly.

I changed the path to ./backups/ still the same error.

Joe2288 09-17-2009 05:47 PM

Ok, I checked a little further into this problem. It does have something to do with permissions.
Folder /backups/ permission is 0777 owner me
Folder /backups/2009-09-17 permission 0777 owner www-data ... does this matter?

So I went on and edited mysqlbackup.php in order to remove the creation of folder as this is somehow creating the problem for me ....

// Cron Based Automated Backup
function cronBackup()
{
/*
Set Full Dump Path.
*/
//$this->FULL_PATH = $this->DUMP_PATH.$this->DATE.'/'.$this->PREFIX.$this->DATE;
$this->FULL_PATH = $this->DUMP_PATH.'/'.$this->PREFIX.$this->DATE;

/* Short Path */

//$this->SHORT_PATH = $this->DUMP_PATH.$this->DATE;
$this->SHORT_PATH = $this->DUMP_PATH;

/*
Close Forum.
*/
if ($this->SHUTDOWN) { $this->forumStatus(0); }

/*
Remove previous SQL Files.
*/
//$this->removeDir($this->SHORT_PATH);
//$this->createDir($this->SHORT_PATH);

/* Clear Cache */
clearstatcache();
..............
............

I no longer have dated folders, but it is working now.

Allan 09-20-2009 06:20 AM

Quote:

Originally Posted by VedicJunction (Post 1883494)
Hi Paul!,, since i cannot wait for the next version of the mod, i tried to patch the mod with this option... :).... i thought of uploading my modifications so that other ppl can benefit.. hope you dont mind...

i have added two options :

IF you choose to "COMBINE FILES" Then:-

1. All the backups now goes into a single backup dir.
2. If on Linux... then you also have a option to produce a compressed .gz file.

Installation :

1. install the original mod.
2. replace mysqlbackup.php with the attached one.
3. Uninstall the product.
4. Re-import the product with the attached xml file.

Important info..
1. the relative path do not work for me... i used full path (/home/sdadsf/backup/)
2. Do not use this if you do not want to combine your files..
3. I am not a php programmer .. so use it at your own risk.!!

Thank you, but don't work for me :(

ChopSuey 10-08-2009 02:05 AM

Tried everything, read all posts, getting an error.

need2fart 10-09-2009 06:02 AM

When I try it, it backs up everything but when it gets to my posts it just stops and says done?

Code:

Processing podcastitem (No Data)
Processing poll (218) : Processed 218 Rows in 0.016 seconds
Processing pollvote (8249) : Processed 8249 Rows in 0.327 seconds
Processing post (136557)

Thats all I see and it says done... I don't think it is right tho because it didn't say the time processed.

Can someone help me with this I think it timed out. =(

ChopSuey 10-09-2009 08:16 AM

How did you get it to work? Whats your path for it?

Paul M 10-09-2009 10:05 AM

Quote:

Originally Posted by need2fart (Post 1896992)
Thats all I see and it says done... I don't think it is right tho because it didn't say the time processed.

Can someone help me with this I think it timed out. =(

That certainly looks like it failed, and timeout is the most likely reason.

ChopSuey 10-09-2009 10:15 AM

Well i can't get it to work, set path to ././backups it fails after.

MagicThemeParks 10-09-2009 11:48 AM

Just changed servers and the file path has to be changed. Where do I make the adjustment for that?

ChopSuey 10-09-2009 12:50 PM

Should be in your vBulletin options..

MagicThemeParks 10-09-2009 11:46 PM

I must be looking in the wrong place. Where in the vBulletin options should I look?

need2fart 10-10-2009 01:45 AM

Quote:

Originally Posted by Paul M (Post 1897037)
That certainly looks like it failed, and timeout is the most likely reason.

Dear Paul M, do you know how I can fix the timeout error?

Log on 10-10-2009 09:47 AM

thank u

Paul M 10-10-2009 10:05 AM

Quote:

Originally Posted by need2fart (Post 1897373)
Dear Paul M, do you know how I can fix the timeout error?

Speak to your host, I cant help with individual server set-ups im afraid.

need2fart 10-10-2009 07:53 PM

Quote:

Originally Posted by Paul M (Post 1897489)
Speak to your host, I cant help with individual server set-ups im afraid.

Wow thank you Paul M! I talked to them and they assisted me to use cpanel cron jobs haha, now no more timeout errors! They said it timed out because of the 30second limit in PHP. Now with cron job though cpanel, no more timeouts!

Thank you for all the help and advice,
and the lovely product,

- Kyle

Cybershaolin 10-14-2009 06:59 PM

I now also have timeouts problem with only 203 tables. It's strange because it worked before but not anymore? It just started recently to give me problems without completing the backup fully, missing the last tables in the database. What exactly do I have to look into my php.ini values in order to find out about the timeout value? What is a good value for timeout? Is there a setting we can adjust in the hack files about timeouts?

Paul M 10-14-2009 09:47 PM

The modification sets the timeout to 3600 (ie 1 hour). However, I believe this may be overridden by any "max_execution_time" setting in your php.ini file. The modification will most likely also timeout in safe mode.

Cybershaolin 10-15-2009 12:58 AM

I looked in the php.ini file and the max_execution_time value is set to 50000 in both local and master value. I guess this is not the problem then. Very weird.

ChopSuey 10-15-2009 06:59 AM

Quote:

Originally Posted by ChopSuey (Post 1896405)
Tried everything, read all posts, getting an error.

Still no answer? Marked as installed and Nominated. Still dont work for me

Paul M 10-15-2009 01:20 PM

You have not supplied any useful information - just simply said it doesnt work.

You must give details of what does or does not happen, error messages etc.

However, please note that I cannot answer questions on individual server set-ups. If you have a permissions error then you need to sort that out yourself, or speak to your host.

Alucard^ 10-16-2009 12:40 PM

Hi,

I have a question, sorry if this is answered but I didn't see nothing about that in the first page.

This plugin make a backup, good, but if I did it a backup (without this plugin) and I want to upload this backup, I can use this for that? or this is only to make backups?

Thanks and sry if I writed something wrong, my english isn't perfect.

Paul M 10-16-2009 01:12 PM

This is only to make backups, not restore them.

euantor 10-16-2009 06:49 PM

Great mod :) Backs up my forums perfectly.

ChopSuey 10-17-2009 12:06 AM

I fixed it, had to fix some of the files and do the config.php file with my own stuff

Log on 10-17-2009 10:38 AM

great

thank u

ForumUser210 11-03-2009 05:27 AM

Perfect!

Thank You!

DontWannaName 11-09-2009 07:05 AM

Worked for me but if we backup everyday to be safe, and it does this for a long time, it will take up a lot of space. How can we delete old backups every month?


All times are GMT. The time now is 02:30 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.01619 seconds
  • Memory Usage 1,820KB
  • 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
  • (7)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