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]