The platform is WinXP. I have database with fields of bytea in Posgresql 8.1. The objective was to transfer the entire databasae (schema + data) to Mysql 5.1. I used the pg_dump from Posgresql 8.1 to extract the schema and data. With some minor touch-up of the sql script generated, I am able to run the script with mysql.exe to store the database except for the bytea data... -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Raymond O'Donnell Sent: Wednesday, May 13, 2009 5:52 PM To: George Kao Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: how to extract data from bytea so it is be used in blob for mysql database On 13/05/2009 21:56, George Kao wrote: > I used pg_dump to extract the data from my database with bytea fields > (having pictures) in plain text format. I encoutered some problems to > restore those bytea data to the blobs field in a Mysql database. Any advice? A bit more detail would be nice.... we're only guessing otherwise. - Platform(s)? - Version? - Commands executed? - Error messages? - Log entries? - .... Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
