Have you looked at the manual? The program mysqldump jumps to mind: http://dev.mysql.com/doc/mysql/en/mysqldump.html
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Seena Blace <[EMAIL PROTECTED]> 09/01/2004 02:04 PM To [EMAIL PROTECTED] cc [EMAIL PROTECTED], Seena Blace <[EMAIL PROTECTED]> Subject Table dump into binary how to take binary/ascii dump of table? [EMAIL PROTECTED] wrote: AFAIK, MySQL servers can only talk to other MySQL servers and that is only through the replication protocol/connections. Beyond that you will need to make your server-to-server connections through some kind of external client. Can Oracle act as a client to foreign databases? If it cannot, I believe you will need to write some code to develop a custom solution. It may be possible to use the MySQL source code to enable your custom client to behave as a MySQL replication slave then transform the binlog entries you receive into valid Oracle statements. Other than that, I think that you would need to periodically poll the MySQL server for changes and duplicate them into your Oracle server. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Seena Blace wrote on 09/01/2004 12:30:12 PM: > Hi, > > I wanted to setup connectivity between mysql database and oracle > database.I have one database in mysql from which all tables data I > want to insert real time data into oracle database.How to connect > mysql database with oracle database? > thanks > > > --------------------------------- > Do you Yahoo!? > New and Improved Yahoo! Mail - Send 10MB messages! Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages!
