vb.org Archive - [vbcron] Automatic database backup [v1.3]

Page 3 of 19

Last »

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)

anabolicedge

03-04-2004 07:34 PM

can someone explain this please? Maybe a text file with some instructions for us that dont know how.

thanks

Mr. HillBilly

03-04-2004 08:47 PM

Why not just have the script get the database info from config.php?

cteselle

03-04-2004 08:59 PM

Great hack! *clicks install*

I modified it a tad to keep a "yesterday" and a "today". I'm sure your new version will incorporate something like this, I just couldn't wait. ;)

PHP Code:


		
			
// move the current file so we can always keep 2 backups

print('mv ' .DUMP_PATH. '/' .DB_NAME. '-today.tar.gz ' .DUMP_PATH. '/' .DB_NAME. '-yesterday.tar.gz 2> /dev/null');



// now execute the backup

print('mysqldump --add-drop-table -h' .DB_HOST. ' -u' .DB_USER. ' -p' .DB_PASSWORD. ' ' .DB_NAME. ' 2>' .DUMP_PATH. '/' .DB_NAME. '-' .DUMP_DATE. '-error.txt >' .DUMP_PATH. '/' .DB_NAME. '-' .DUMP_DATE. '.sql');



if (DUMP_MAKE_TAR == '1')

{

    // now archive and compress the backup

    print('tar -cSz --remove-files -C' .DUMP_PATH. ' -f' .DUMP_PATH. '/' .DB_NAME. '-today.tar.gz ' .DB_NAME. '-' .DUMP_DATE. '.sql ' .DB_NAME. '-' .DUMP_DATE. '-error.txt'); 

}

kristian

03-05-2004 09:44 AM

Well - this is just not working!!! I have configured it with my own details and have put it in the scheduled tasks list but when I do 'run now' no backup is run!!!

Does my server need to have 'Safe Mode' turned off by any chance? :ermm:

AlexanderT

03-05-2004 09:57 AM

Quote:

Originally Posted by Brad.loo

Hey guys, im busy today (I just got done dumping a ton of trash with a tractor! LOL) but if I get time I may update this one today, if not tomorrow.

Planned improvements:

Zip file type support
Delete last backup when doing current one
Close boards when backing up
Clear session table before backup
Options to NOT include stuff like the postcache in the backup

Wonderful!!!

Floris

03-05-2004 10:34 AM

Quote:

Originally Posted by Mr. HillBilly

Why not just have the script get the database info from config.php?

exactly :)

ThePartyBorg

03-05-2004 12:17 PM

Quote:

Originally Posted by Brad.loo

TPB:

I'll look into that for you, however the backup would then consume alot of bandwidth with the transfer to the new server :)

Well, we don't really have a big database (about 8k posts), and have plenty of bandwidth already, so a few more wouldn't be a problem.

gmarik

03-05-2004 04:17 PM

Sounds good. Where could I found more info about it?

Mr. HillBilly

03-05-2004 07:25 PM

Question, Once it gets does it deletes the .sql file and leaves the tar.gz right?

I ran this my self from adminCP and my browser timed-out waiting for it to finish :|

Morpheus84

03-06-2004 03:53 PM

At my vB3 the Script won't will be work :(
I click on "Do it now" and my vB says "All done."
On my FTP Server there's nothing to see about a backup :(

Plz help.

All times are GMT. The time now is 10:19 PM.

Page 3 of 19

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01133 seconds Memory Usage 1,748KB 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_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: