Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Run a MySQL statement via cron

Jul 15, 2003, 8:29 PM
carfac
Veteran (1240 posts)
carfac's avatar
Jul 15, 2003, 8:29 PM
Post #1 of 3
Views: 5923
Shortcut
Quote Reply
Run a MySQL statement via cron
Hi:

I have a colo server, but my ISP hosts my MySQL... so I do not know mysql too very well at all.

I have a cron job I would like performed on my MySQL data once a month. OK, I can setup the cron just fine, I am just not sure HOW I would send the mysql statement. I know what I would send in the MySQL command boq inMySQLMan... I would send:

update Links set mon_hit = '0'

(I keep my hits tracking cumulative in Links, but I also run a monthly "Most Hits"...- I just want to reset that, and I often forget.)

so the MySQL server is at usersql.aros.net, username dave password links...

Would I want to run a quick perl script, or can I run a command linke in crom to do this? And- this is the biggy!- how would I write the statement?

TIA!
dave

Big Cartoon DataBase
Big Comic Book DataBase
Jul 15, 2003, 9:16 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Jul 15, 2003, 9:16 PM
Post #2 of 3
Views: 5825
Shortcut
Quote Reply
Re: [carfac] Run a MySQL statement via cron In reply to
You can do either (perl or shell script) or even in PHP.

With a shell script, you would something like the following:

Code:

#!/bin/sh
mysql -u user -p db
update Links set mon_hit = '0';
exit

========================================
Buh Bye!

Cheers,
Me
Jul 16, 2003, 8:07 AM
carfac
Veteran (1240 posts)
carfac's avatar
Jul 16, 2003, 8:07 AM
Post #3 of 3
Views: 5738
Shortcut
Quote Reply
Re: [Stealth] Run a MySQL statement via cron In reply to
Thank you Eliot!
dave

Big Cartoon DataBase
Big Comic Book DataBase