Can any one tell me if it is possible to run a MySQL query within a cron job command ?
If it is possible .. can you tell me how ?
Just to let you know am using a cron manager within CPanel 9
Greg
A cron job question...
Moderator: General Moderators
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England
Sure it is, you can run pretty much anything, just have the command as something like:
Or you could have it read the SQL queries from a text file. Just have a play about and see what works.
Code: Select all
mysql -u bob -password=blah mydatabase < "UPDATE table SET rah = '4' WHERE id = '1';"yes you can
Yes you can do that with a cron job. Here is a good webpage to help
Khalid Gourad
Khalid Gourad