Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 10-06-2008, 11:54 PM
ATVTorture ATVTorture is offline
 
Join Date: Sep 2008
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default cron job for a SQL function???

Is there a way to create a scheduled task that will run a SQL query. I would like to create one that will run on schedule a SQL function that, at say 3AM (a low user load time), that will make a copy of my database with a date and time stamp on the name it saves. I can handle the date and time stamp on the file name with SQL. I just need to know if I can automate the SQL function.

Thanks!
Buster
Reply With Quote
  #2  
Old 10-06-2008, 11:58 PM
Eikinskjaldi's Avatar
Eikinskjaldi Eikinskjaldi is offline
 
Join Date: Feb 2006
Location: Hell, never looked better
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You can drop a vb script (with access to the mysql classes) into includes/cron and set it up as a cron in the admincp.

Alternatively, you can use a scripting language with mysql support and set it up using the system cron.

Both ways will work fine, although with the vb approach the cron will fire the first time someone (anyone) views some part of your site on or after your trigger time.
Reply With Quote
  #3  
Old 10-07-2008, 12:35 AM
ATVTorture ATVTorture is offline
 
Join Date: Sep 2008
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OK, you just went over my head. How do I implment what you're saying?

Thanks!
Buster
Reply With Quote
  #4  
Old 10-07-2008, 02:33 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, you can do it. All the cron jobs are kept in the includes/cron/ folder. Just find a simple one, give it a new name, remove the code in the middle, and add your own code instead. Save. Create a scheduled task to run it.
Reply With Quote
  #5  
Old 10-07-2008, 05:15 PM
ATVTorture ATVTorture is offline
 
Join Date: Sep 2008
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OK, maybe I was giving myself too much credit. How would I write the script to just get it to make a copy and save it somewhere on the server with a static name. In other words if my DB is called vbdatabase and I want it to dump to a folder off the root called backup, overwriting the previous file, how would I code that?

Thanks!
Reply With Quote
  #6  
Old 10-07-2008, 05:31 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you thought of installing one of the mods written to already do this? (search "backup" "all mods" "titles only")
Reply With Quote
  #7  
Old 10-07-2008, 08:12 PM
ATVTorture ATVTorture is offline
 
Join Date: Sep 2008
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Holy cow, wouldn't have thought there was such a mod out there. Wonder if there's one that can do a backup of an entire folder like that. Spose I'll have to search for that too now.

Thanks for pointing me in the right direction Lynne.

Buster
Reply With Quote
  #8  
Old 10-07-2008, 08:15 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ATVTorture View Post
Holy cow, wouldn't have thought there was such a mod out there. Wonder if there's one that can do a backup of an entire folder like that. Spose I'll have to search for that too now.
Look no further than my profile for that sort of mod. It's the only mod I've ever submitted.
Reply With Quote
  #9  
Old 10-07-2008, 08:47 PM
ATVTorture ATVTorture is offline
 
Join Date: Sep 2008
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sweet, i was just looking at that mod!

Great work Lynne!

Buster
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:56 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04165 seconds
  • Memory Usage 2,229KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete