Copying of table rows between two different Mysql Servers
Hermann Matthes <[email protected]> Sun, 25 Jan 2009 02:30:29 +0100
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
Hallo all, I have a multi database environment where it's sometimes neccessary to copy a table row from a database on server 1 to a row in a table with identical structure in another database on server 2. One of those tables contains a BLOB, which in fact stores a binary pdf file. By now I'm reading the blob into a temporary file and afterwards I'm storing this file in the target blob. Is there a way to get rid of the temporary file? In my mind the best solution would be to directly copy from database 1 to database 2 using InputStream and OutputStream. Does anybody know how to achieve this? Any hint is welcome. Regards Hermann -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]