[lug] cron and mysql

[Michael Belanger]

On Sunday 12 March 2006 8:57 am, Luke P found the courage to say:
> Hey,
>
> I am thinking about running a cron job that runs a mysql script, is that
> possible and if so, can you point me in the direction of some docs on doing
> that? In addition, I am not sure if cron is the best method for running
> scheduled sql scripts, if you have a better idea, let me know.


You may also be interested in 'sja for linux' at http://www.webyog.com.. We 
use it for syncing multiple databases in cron.. works extremely well... 
though, you may not be syncing exactly.



>
>
>
> Thanks!
>
> Luke
>
>
>
> p.s. if you are curious, the script I'm thinking of running is one where I
> select from one table and insert into another, again, if you think there's
> a better way than a script, let me know.

-- 
Michael Belanger
CICLOPS, Space Science Institute

phone. 720-974-5853   Jabber: mrb at jabber.ciclops.org
fax.   720-974-5860

DISCLAIMER:
The Sender and Cassini Imaging Central Laboratory for Operations
accepts no liability for the content of this email, or for the 
consequences of any actions taken on the basis of the information 
provided, unless that information is subsequently confirmed in 
writing. If you are not the intended recipient you are notified 
that disclosing, copying, distributing or taking any action in 
reliance on the contents of this information is strictly prohibited.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 191 bytes
Desc: not available
URL: <http://lists.lug.boulder.co.us/pipermail/lug/attachments/20060312/2afe56cc/attachment.pgp>