MySQL Forums
Forum List  »  Data Warehouse

Stored procedure and connexion to another MySQL DB
Posted by: discmat discmat
Date: March 23, 2010 01:53AM

I would like to retrieve some information from another MySQL database, modify data and load it in a MySQL DB.
To do it regularly, I'll use a stored procedure with an event.
So, is it possible to create a stored procedure in database 1 which will connect and get information from database 2 ? And what is the syntax to do it ?

With this method, I have many other questions :
* If the 2 databases are on the same server, can I have 2 versions of MySQL ? Because the database source use an older version of MySQL which does not support the Event Scheduler".
* Is my solution possible if the 2 databases are not on the same server ?

Thanks all,
I look forward

Options: ReplyQuote

Written By
Stored procedure and connexion to another MySQL DB
March 23, 2010 01:53AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.