vb.org Archive
Page 4 of 5 « First 23 4 5
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   [vbcron] Automatic database backup [v1.3] (https://vborg.vbsupport.ru/showthread.php?t=62149)

xQuEeNzNaZcHox 05-18-2004 07:07 PM
Great hack, one question: I turned on Log Entries, and I looked in the folder where the backup was (after it had backed up), and it had a file called "05-18-04-error.txt." It had nothing on it.

Anything wrong here?

Matrixgl 05-24-2004 10:04 PM
I am not trying to discourage people from using this hack, but this is just a suggestion for people who wants more features.

The script that I use can be used to make backups of any database, and it has all the features that you probably need.
  • Backup multiple databases and servers with different users and passwords.
  • Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems).
  • Create daily, weekly and monthly snpashots of your database.
  • Keep the daily, weekly and monthly backups for a user-specified time.
  • Archive and compress the SQL files (*.tar.gz).
  • Creates a detailed report of everything that has been done.
  • Reports can be mailed to you or any other user- specified email- address, saved to disk or displayed in browser.
  • Generated SQL files can be mailed to you or any other user-specified email-address.
  • Generated SQL files can be saved on the server.
  • Choose to create SQL files for each table or one for each database.
  • No system calls, everything in 100% pure PHP. PHP Safe-mode compatible.

http://restkultur.ch/personal/wolf/scripts/db_backup/

Boofo 05-24-2004 10:31 PM
Quote:
Originally Posted by Matrixgl
I am not trying to discourage people from using this hack, but this is just a suggestion for people who wants more features.

The script that I use can be used to make backups of any database, and it has all the features that you probably need.
  • Backup multiple databases and servers with different users and passwords.
  • Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems).
  • Create daily, weekly and monthly snpashots of your database.
  • Keep the daily, weekly and monthly backups for a user-specified time.
  • Archive and compress the SQL files (*.tar.gz).
  • Creates a detailed report of everything that has been done.
  • Reports can be mailed to you or any other user- specified email- address, saved to disk or displayed in browser.
  • Generated SQL files can be mailed to you or any other user-specified email-address.
  • Generated SQL files can be saved on the server.
  • Choose to create SQL files for each table or one for each database.
  • No system calls, everything in 100% pure PHP. PHP Safe-mode compatible.
http://restkultur.ch/personal/wolf/scripts/db_backup/
How hard is it to set up?

Matrixgl 05-24-2004 10:47 PM
not hard, just unzip/untar, upload, change the variables in config.inc.php and thats it. You have to set up a cron though. You can either do it using telnet or cpanel.

See the installation section on the site.

Fluous 06-03-2004 08:35 PM
So this is all done and I can download it? Like it should work on my system? And I should download the db back up but only put it on my server when I need to back up?

Bulent Tekcan 06-04-2004 12:24 PM
When I use this script my DB is 411MB but in AdminCP VBBackup system make a 444MB ??? Why different size ? Also both extension is .sql

Thanks

Bulent Tekcan 06-05-2004 12:14 PM
Quote:
When I use this script my DB is 411MB but in AdminCP VBBackup system make a 444MB ??? Why different size ? Also both extension is .sql


Thanks
I cannot receive any answer my questions manytimes.....

Anybody knows why size is diffrent ????

Bahawolf2 06-05-2004 02:53 PM
Quote:
Originally Posted by Matrixgl
I am not trying to discourage people from using this hack, but this is just a suggestion for people who wants more features.

The script that I use can be used to make backups of any database, and it has all the features that you probably need.
  • Backup multiple databases and servers with different users and passwords.
  • Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems).
  • Create daily, weekly and monthly snpashots of your database.
  • Keep the daily, weekly and monthly backups for a user-specified time.
  • Archive and compress the SQL files (*.tar.gz).
  • Creates a detailed report of everything that has been done.
  • Reports can be mailed to you or any other user- specified email- address, saved to disk or displayed in browser.
  • Generated SQL files can be mailed to you or any other user-specified email-address.
  • Generated SQL files can be saved on the server.
  • Choose to create SQL files for each table or one for each database.
  • No system calls, everything in 100% pure PHP. PHP Safe-mode compatible.

http://restkultur.ch/personal/wolf/scripts/db_backup/
The only problem I experienced with this script was when a database copy was already there, and it tried backing it up again, which caused the new backup to increase in size ridicuously (monitored by refreshing on WSFTP) until it just stalled. I have a cron setup obviously.. any advice?

As for this hack, I had no success in getting my backup. It makes a .tar the size of 1KB without any files.

SaN-DeeP 06-06-2004 09:10 PM
:S

Noone using this error got this except me.
i guess, my hosting provider has banned/blocked something or its me ?

Here is the Error. no db backup is created in my backup dir which is properly CHMOD.

Code:
Warning: exec() has been disabled for security reasons in /forums/includes/cron/vbcron_db_backup_131.php on line 38

Warning: exec() has been disabled for security reasons in /forums/includes/cron/vbcron_db_backup_131.php on line 47
Database backup script was invoked without error, to check that it was done correctly see if the file was written to the folder you specified in the configuration variables. It may take some time before your server finishes backing up depending on the size of your database
need help.

Thnx.
Sandy...

Bahawolf2 06-06-2004 11:00 PM
Quote:
Originally Posted by SaN-DeeP
:S

Noone using this error got this except me.
i guess, my hosting provider has banned/blocked something or its me ?

Here is the Error. no db backup is created in my backup dir which is properly CHMOD.

Code:
Warning: exec() has been disabled for security reasons in /forums/includes/cron/vbcron_db_backup_131.php on line 38

Warning: exec() has been disabled for security reasons in /forums/includes/cron/vbcron_db_backup_131.php on line 47
Database backup script was invoked without error, to check that it was done correctly see if the file was written to the folder you specified in the configuration variables. It may take some time before your server finishes backing up depending on the size of your database
need help.

Thnx.
Sandy...
I forgot what this was called..
I think its something with php.. like php(exec) or something..

Your host may have it disabled.. let me check into this further.

Brad 06-08-2004 03:44 AM
Hey guys, ive been busy again.

2.0 is coming, just alot of code to make sure these commands are correct for all options. Advanced users are going to enjoy some more control over the way back-ups are made, and you will have the option of dumping the raw db files instead of a .sql text file.

The new version should work on any mysqldump or mysqlhotcopy command enabled server, I have some more testing to do before I feel ok about releasing it, but I promise it'll be up soon. :)

Aurous 06-09-2004 10:40 PM
sweet, have been waiting for version 2.0 since it was announced! cant wait :cool:

Brad 06-10-2004 03:55 PM
Quote:
Originally Posted by Aurous
sweet, have been waiting for version 2.0 since it was announced! cant wait :cool:
Aye sorry about the wait, been hitting the books, still got four more tests to do before I get lots more free time :). This is something im using on my own site aswell, it's getting stress tested over and over as I test ipb imports.

Natch 06-11-2004 01:05 PM
brad.loo - ust letting you know but I have found that this script has caused seg faults and 83% CPU usage while running ...
Quote:
Originally Posted by my hosting provider
Your account is using a backup recovery program which is causing the server
load to be very unstable and prone to http segmentation fault errors.

Top Process %CPU 85.3 tar -cSz --remove-files -C/home/mofo/forumdump
- f/home/mofo/forumdump/Wednesday.tar.gz Wednesday.sql Wednesday- error.txt
Top Process %CPU 85.2 tar -cSz --remove-files -C/home/mofo/forumdump -
f/home/mofo/forumdump/Wednesday.tar.gz Wednesday.sql Wednesday- error.txt
Top Process %CPU 84.8 tar -cSz --remove-files -C/home/mofo/forumdump -
f/home/mofo/forumdump/Wednesday.tar.gz Wednesday.sql Wednesday- error.txt
Just a FYI - the DB I'm backing up is not very large - I dunno if it's a peculiartiy to my server, or what - but worth looking into ...

MrNase 06-15-2004 04:59 PM
Hey Brad, is 2.0 done? ;)

Iam waiting for it soooo badly because i really need that hack :(

teksigns 06-15-2004 05:18 PM
looking for 2.0 ...... where are you ?

lol

bahawolf 06-15-2004 06:35 PM
Doesn't appear 2.0 is done.. :/

SaN-DeeP 06-15-2004 11:05 PM
Quote:
Originally Posted by bahawolf
Doesn't appear 2.0 is done.. :/
wait and dont cry
it will be out when it is out :)

Bahawolf2 06-16-2004 02:54 AM
I wasn't.. ;)
I was simply telling the other members that it wasn't done because that was like the second member asking for it.. ;)

Brad 06-22-2004 12:46 AM
2.0 is coming guys, you just have to wait a bit longer.

Quote:
brad.loo - ust letting you know but I have found that this script has caused seg faults and 83% CPU usage while running ...
I have not seen cpu that high with the script before, altho it is very possible depending on the server and amount of traffic on it.

Natch 06-22-2004 01:37 AM
It was just related to this script, particularly to the level of compression used in the tar-gz

Brad 06-22-2004 01:46 AM
2.0 will solve this indirectly, while it will still make tar's if you want, you can set it to use other compresstion engines.

Aurous 06-27-2004 08:22 PM
Quote:
Originally Posted by Brad.loo
2.0 is coming guys, you just have to wait a bit longer.
Its been about a week since you announced that, so wondering how long it will take to get this out. Well if its taking longer, thats fine, take your time, test it for bugs, etc. .. no hurry :-)

stamos2003 06-28-2004 11:59 AM
very cool and usefull, thx. !

Brad 06-29-2004 03:11 AM
Quote:
Originally Posted by Aurous
Its been about a week since you announced that, so wondering how long it will take to get this out. Well if its taking longer, thats fine, take your time, test it for bugs, etc. .. no hurry :-)
I did'nt have time this weekend due to a death in the family, i'm back on the job now :)

gwhooooey 07-11-2004 05:23 AM
Any update on the new version?

WEForums 07-15-2004 01:20 AM
Nice and all. Installed.

I'm just wondering, though, if there is any way I could see if it's a full database backup? Opening the file is a little rough with having so many users and posts, so it requires so much RAM...

So how would I know if it's a good backup? Just estimate the size?

teksigns 07-15-2004 02:08 AM
any estimate on 2.0 ?

been holding off installing this one in hopes of the new version ....

gwhooooey 07-15-2004 02:36 AM
Quote:
Originally Posted by teksigns
any estimate on 2.0 ?

been holding off installing this one in hopes of the new version ....
Same

Koutaru 07-15-2004 05:39 AM
Quote:
Originally Posted by Brad.loo
I did'nt have time this weekend due to a death in the family, i'm back on the job now :)
Sorry to hear that :( I hope you're alright

^_^ Delete last .sql (or .tar.gz) file when doing current back-up is the only part I'm really looking forward to.

Bison 07-24-2004 04:34 AM
Yeah ... take your time Brad.loo. Personal life is most important!

Don't rush because a few can't wait. With some time, I know you'll produce a great script! :)

Sanity 07-27-2004 02:28 PM
Thx for this skript!

I use it once per day and it is great. But I get always three files instead of one: I got the error.txt, the *.sql and the *.tar.gz files. Everything seems to be ok but i would like only to have the *.tar.gz file.

SnowBot 07-27-2004 03:14 PM
Quote:
Originally Posted by Bison
Yeah ... take your time Brad.loo. Personal life is most important!

Don't rush because a few can't wait. With some time, I know you'll produce a great script! :)
I agree, its working great as it is so we can hang for the update, just relax for awhile :)

xTerMn8R 08-05-2004 07:10 PM
Will this hack also work on a Windows 2000 Server running VB 3.03?

NietzscheKid 08-05-2004 07:43 PM
My condolences Brad. :(

weirdpixels 08-12-2004 12:40 PM
will this hack work if I have my database on one server and my vb files etc on another?

SamirDarji 10-21-2004 07:31 PM
Any news on 2.0? Will it work with 3.0.3? Can someone summarize the changes that are available to this hack?

SamirDarji 10-21-2004 10:02 PM
Quote:
Originally Posted by Matrixgl
I am not trying to discourage people from using this hack, but this is just a suggestion for people who wants more features.

The script that I use can be used to make backups of any database, and it has all the features that you probably need.
  • Backup multiple databases and servers with different users and passwords.
  • Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems).
  • Create daily, weekly and monthly snpashots of your database.
  • Keep the daily, weekly and monthly backups for a user-specified time.
  • Archive and compress the SQL files (*.tar.gz).
  • Creates a detailed report of everything that has been done.
  • Reports can be mailed to you or any other user- specified email- address, saved to disk or displayed in browser.
  • Generated SQL files can be mailed to you or any other user-specified email-address.
  • Generated SQL files can be saved on the server.
  • Choose to create SQL files for each table or one for each database.
  • No system calls, everything in 100% pure PHP. PHP Safe-mode compatible.

http://restkultur.ch/personal/wolf/scripts/db_backup/
I've been messing with this for a little while in a scheduled task in the vb cron. On my local test server, it works fine. But on the production server, I get a "Internal Server Error" when I try to manually run the job. Any clues?

dethfire 11-04-2004 06:44 PM
yeah any status? seems like a few months since an update

dethfire 11-04-2004 06:48 PM
also will this timeout on a large database?


All times are GMT. The time now is 07:45 PM.
Page 4 of 5 « First 23 4 5
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.01669 seconds
  • Memory Usage 1,838KB
  • 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
  • (2)bbcode_code_printable
  • (14)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