Re: how to extract data from bytea so it is be used in blob for mysql database

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Raymond
O'Donnell
Sent: Wednesday, May 13, 2009 5:52 PM
To: George Kao
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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(at)iol(dot)ie Galway Cathedral Recitals:
http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To
make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general