FUDforum: Database discussions » Scheduling Actions

Home » General » Database discussions » Scheduling Actions - Automation 101 question.

Show: Today's Messages :: Polls :: Message Navigator

Scheduling Actions - Automation 101 question. [message #4004]

Thu, 11 July 2002 18:57

jkrische2

Messages: 32
Registered: February 2002
Location: Topeka, KS

Karma:

Member

Hello all!

I have a minor problem to solve. I have a MySQL DB hosted out on a remote server. This DB accumulates a lot of junk records in the course of its processing, and I would like to prune them.

So, I would like to find a way to create some sort of batch file/cron job/whatever scheduled script that instructs MySQL to find records of certain criteria & deletes them, let's say daily, in a completely unattended fashion.

I have a WinXP Pro and a MacOSX 10.1.5 box available to accomplish the task (will use whichever is easier & more appropriate for the job), and need to do it as cheaply as possible - some expense is OK, but not too much. Does anyone have any suggestions, or could at least point me to a resource somewhere that is on-point?

Thanks!

John Krische

Report message to a moderator

[Message index]

		Scheduling Actions - Automation 101 question. By: jkrische2 on Thu, 11 July 2002 18:57
		Re: Scheduling Actions - Automation 101 question. By: Ilia on Thu, 11 July 2002 19:59
		Re: Scheduling Actions - Automation 101 question. By: jkrische2 on Thu, 11 July 2002 20:22

Previous Topic:	binding mysql to localhost (I/O)
Next Topic:	Getting aborted connections

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 05:28:45 GMT 2024

Total time taken to generate the page: 0.04800 seconds