FlashbackJon Posted April 18, 2007 Share Posted April 18, 2007 My virtual host is running MySQL 4.0.25, and I do most of my database work via phpMyAdmin 2.6.4-pl4. I want to be able to schedule queries or scripts to run nightly at a specified time, and I don't think phpMyAdmin can do that. I've found a couple free schedulers online, but they look a little shoddy. Can anyone recommend something for scheduling SQL queries? Quote Link to comment Share on other sites More sharing options...
AndyB Posted April 18, 2007 Share Posted April 18, 2007 cron is exactly what you need, accessed from any decent server control panel Quote Link to comment Share on other sites More sharing options...
FlashbackJon Posted April 18, 2007 Author Share Posted April 18, 2007 Hrm. I like this cron. Okay, let's step back and pretend I'm more noobish than I let on. Let's also pretend that my server control panel is a quite a bit less than decent (although I'll be remedying this shortly). It appears from the table listing in phpMyAdmin that my forum (vBulletin) is using cron for its scheduled tasks (upon noticing the "cron" and "cronlog" tables. Upon further inspection, I can add my own scheduled tasks by way of vBulletin's admin panel, and it appears as though I can simply specify a PHP script to run. In theory, I could hijack my own forum software to run scheduled scripts for whatever else I wanted in the same database... ...right? Quote Link to comment Share on other sites More sharing options...
AndyB Posted April 18, 2007 Share Posted April 18, 2007 In theory, I could hijack my own forum software to run scheduled scripts for whatever else I wanted in the same database... ...right? Possibly. There might be some permissions issues, i.e. you can't play outside the VBulletin sandbox. Easily resolved by giving it a try Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.