Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux