vb.org Archive
Page 3 of 3 12 3
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 - Automatic Database Back-up (https://vborg.vbsupport.ru/showthread.php?t=114097)

creedmaniac 05-02-2006 11:31 AM
Quote:
Originally Posted by LiveWire
@creedmaniac: Thanks for the quick PM! Okay make sure that your File Dump Path setting is set to the following.

I would suggest place this in a folder outsite of the public_html folder for security reason. To do this, log into your website via FTP. This will place you in the /home/inara/ directory. Create a folder and name it whatever you want. I named mine databack.

Once you have finished that. Log into your admincp panel and make your way to the Database Backup Settigs. This is under the vBulletin Options. Make your your File Dump Path settings is set to /home/inara/databack (no ending slash). Then run the cron and give it a good 15 mins to transfer the database to that folder. The time all depends on the size of your database. Let me know if that fixed it. :)
that's what it's already set to, so nope...still getting a .sql and an error.sql

Logikos 05-02-2006 12:39 PM
@hadog I'm still looking into this issue with mysql5. I'm hoping to update this hack soon and see why mysql5 is causing problems.

@creedmaniac: This should add a file called 05-1-2006.sql and 05-1-2006-error.txt to your /home/inara/databack directory. If you have it set to .tar.gz, then you will only get a 05-1-2006.tar.gz file in the directory. 05-1-2006 is the date of the current backup. At the moment the error files do not process when your using the .tar.gz menthod. This isn't a bug, this is just by design. I'll be updating some settings soon.

Are you at least getting the backups to the directory?

To Everyone
Is there anyone else using this hack with MySQL5? If so, is it working?

5wayshosting 05-06-2006 05:14 AM
Thanks for this hack..

Logikos 05-06-2006 11:03 AM
No problem. :)

rmxs 05-06-2006 03:18 PM
hi nice hack byt i use it 3 days and my 3 backups its empty...now i change the option to do backup without compresion byt i dont thing thats my problem.
anyone have idea?

Edit:Same thing also without compres.(empty file)also one txt file apeard with this inside..

sh: line 1: mysqldump: command not found

Logikos 05-06-2006 07:39 PM
Thats what the error.txt file is for. It's letting you know that mysqldump: command not found. Means you don't have that feature installed on your server. You would have to ask your host to enable it or install it. (mysqldump)

rmxs 05-06-2006 07:45 PM
LOL i forget this step :) thanks for responce

kurtbarker 05-07-2006 04:46 AM
Hey LiveWire... When I used to do this manually using the ACP, I was getting database sizes of over 100mb, using the auto system i'm getting database sizes of just over 90mb... is it missing something in the backup?

rmxs 05-07-2006 03:01 PM
No its normal...my db its 80 and im get 73mb backup

Smiry Kin's 05-07-2006 03:49 PM
an option to go to a throw from back up databases would be cool..

no possible way to make this able to go to another FTP address?

Quarterbore 05-09-2006 12:46 AM
Is there any advantage to using this over a traditional server driven CRON job?

For those that can not get this to run on your server because of the settings... if you server allows you to run CRON jobs I have a page that can help you program your own CRON jobs to back up your MySQL databases here:

http://adultwebbusiness.com/adultbus...topic.php?t=54

No worry, there is no adult content on there ;)

Oh yea, that is one of my sites I have not upgraded to vB yet too...

cclaerhout 05-15-2006 12:06 PM
Quote:
Originally Posted by Feckie (Roger)
Backing up to an external ftp site

(Offsite To Where The Main Server Is)

And the answer is... ? :D ;)

Logikos 05-15-2006 02:20 PM
I'll see what I can do. That is something that I've never done and will need alot of research and testing before I can insert that addon to this hack.

cclaerhout 05-15-2006 02:59 PM
Thanks for your answer :)

I hope you will succeed !

Yorixz 05-15-2006 05:02 PM
Wonderful addon, you got my vote in the poll for sure.

I've got one little feature request which I'm sure of that there will be others who'd like it as well; maybe you can add it so you can specify the max. number of backups you want to keep stored. I, and I'm sure I'm not alone, am on a shared hosting so I haven't got "unlimited" space, therefore I'd love to see a feature to simply have 3 backups at all time; when a new one is made the last one could be deleted to make room.

Keep up the great work and hopefully you'll add it ;)

Logikos 05-15-2006 05:03 PM
Thats a nice idea! I will look into that as well. Thanks for your vote! :)

RemiAlone 05-15-2006 07:51 PM
Installed it but my host has exec disabled. :(

Tim. 05-16-2006 08:31 PM
Installed and running now. When I run it though my site slows to a crawl, a lot of timeouts and such.

How long does it take to make a backup? (1gig sql uncompressed db here)
Can I stop it halfway through somehow?

EDIT: Also, I only see how to make this run Every X Time. Is there a way to say run at 5am GMT+1 every day, for example?

EDIT2: Alright it seems the lag was caused because the script ran 3 SQL Dumps at the same time. Every time the server admin tried to kill one it started over again. Any idea why this happened? The script was set to run once every 23 hours.

Tralala 05-26-2006 07:28 AM
Quote:
Originally Posted by Yorixz
I've got one little feature request which I'm sure of that there will be others who'd like it as well; maybe you can add it so you can specify the max. number of backups you want to keep stored. I, and I'm sure I'm not alone, am on a shared hosting so I haven't got "unlimited" space, therefore I'd love to see a feature to simply have 3 backups at all time; when a new one is made the last one could be deleted to make room.

Keep up the great work and hopefully you'll add it ;)

Agreed, great idea. As it stands now I'll probably have to manually clean out the backup folder from time to time.



I also think it's a good idea to suggest putting a simple index.html file in File Dump Path... otherwise in the off-chance someone guesses the backup directory name, they'd be able to download all of the forum backups simply by navigating to it in their browser.

Angelus 06-03-2006 07:09 PM
hi.

the hack ist very well. thanks for this. BUT i have one error message:

Code:
Datenbankfehler in vBulletin 3.5.3:

Invalid SQL:

                                        UPDATE session
                                        SET lastactivity = 1149365202, location = '/admincp/cronadmin.php?do=runcron&cronid=15', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
                                        WHERE sessionhash = '1104b4313e8dc9116022d6011e23ece3';

MySQL-Fehler : Lost connection to MySQL server during query
Fehler-Nr.  : 2013
Datum        : Saturday, June 3rd 2006 @ 10:07:13 PM
Skript      : http://www.twingo24.de/admincp/cronadmin.php?do=runcron&cronid=15
Referrer    : http://www.twingo24.de/admincp/cronadmin.php?do=modify
IP-Adresse  : xxx
Benutzername : Karlheinz
Klassenname  : vb_database
i hope for help

Logikos 06-06-2006 09:51 PM
You Lost connection to MySQL server during the cron. This could have been a number of things and not just this hack. Try running the script again. If the problem still continues then let me know. You might have to ask you host why this is happening. BTW, how big is your forum?

FreshFroot 06-07-2006 03:37 AM
The weird part I had, was when I ran the task, I checked my folder. It has 2 files, 06-7-2006-error.txt and has a 06-7-2006-.sql......

What's that mean? My database wasn't backed up properly?

Logikos 06-07-2006 04:38 AM
The 06-7-2006-.sql should be your database file. The error text is there to tell you if any errors occoured while backing up the system. How big is your 06-7-2006-.sql file?

FreshFroot 06-07-2006 08:55 PM
I believe it is 25MB... which seems too small I think? The sql file says 0kb, so I wouldn't be able to figure out the error?

AndyP 06-09-2006 11:49 AM
Installed and got it working (after taking a while to figure out the settings I needed).
Great mod. Just what we needed.

Replicators 06-12-2006 12:55 AM
My host automatically does this, but i think this is even better as i can have my other admins do a restore without having to go in the ops. Great mod for people who don't have hosts that do this automatically!

Boofo 06-12-2006 01:11 AM
Mine did too and when the HD crashed and I lost the site, guess which drive the backup they do was on. :cross-eyed:

briansol 06-20-2006 02:01 PM
something seems odd in my backup from last night. Out of no where it jumps extensively.

I store attachments in the file system, so thats not the cause. I KNOW I didn't have 80mb worth of members and posts yesterday.

Anyone see anything like this before? I have no error logs or anything...

:banana:

melefire 06-21-2006 09:52 AM
Thanx works great


All times are GMT. The time now is 07:54 PM.
Page 3 of 3 12 3
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.01186 seconds
  • Memory Usage 1,783KB
  • 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
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (29)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