No. You will need to use an application external to the server to perform
the data collection process. This application can be one you write
yourselves or something you purchase. There are many ways to perform
things on a schedule:
a) you application continuously runs and performs certain actions
according to an internal timer
b) the operating system uses one of its task scheduling services to launch
your application according to a schedule you set.
There are absolutely too many ways to solve your problem to answer your
question any more specifically.
Unimin Corporation - Spruce Pine
Ananda Kumar <anandkl@stripped> wrote on 09/15/2005 10:56:36 AM:
> Hi Green,
> Thanks for the answer.
> We are planing to have reporting database on mysql. This reporting
> database needs to get data from oracle database on a daily basis. It
> would drop the table and get the fresh data from oracle database. So
> can this be done using database link.
> On 9/15/05, SGreen@stripped <SGreen@stripped> wrote:
> Ananda Kumar < anandkl@stripped> wrote on 09/15/2005 10:33:16 AM:
> > Hi,
> > How can i connect from MYSQL db to an oracle database. Do we need to
> > any database link or use some ODBC.
> > Please help
> > regards
> > anandkl
> The only way to get one MySQL database server to directly manage
> data in a table that resides within another server is through the
> Federated storage engine. Federated is a new feature coming with v5.
> 0 and is similar to MSSQL's "linked table" feature. Currently it
> only supports MySQL to MySQL table interactions.
> When you say "connect from MYSQL db to an oracle database" what
> exactly are you trying to accomplish? What are you trying to do?
> What problem are you having that you think the "connection" would
> solve? Please give us some additional details so we can answer your
> question more thoroughly.
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine