mysql and job equivalent.......

[tossi]

Hi pals

I have a MS SQL server, there I have a DTS (data transformation services) package designed, the MS SQL connects to a DB2 Database on an IBM AS400server, gets some data from specified tables and replicates them locally on the MS SQL Database.

I need to do the same using MySQL, I'dont know if Cron will do the job or does the latest version of MySQL has this feature, and how do I use it.

How do I connect to a DB2 database from MySQL to grab some data, and how do I schedule this task to run every certain time?

I have the latest stable version of MySQL as of August 2006 installed on Ubuntu 6.06 Server

Waiting for your replies -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[croft]

Hi

You don't do it from inside MySQL since mysql doesn't contain a scheduler.

You have to use cron and some external script that retrieves the data from DB2 and imports it into mysql.

Hope I was of some help -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[keith]

Originally Posted by croft

You don't do it from inside MySQL since mysql doesn't contain a scheduler.

FWIW, v 5.1 (which is in beta now) will have the internal scheduler -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --