On Tue, May 17, 2005 at 10:07:17AM +0700, Tito Mari Francis Esca?o wrote: > Good day! > > I need pointers about database schema and data migration from MySQL to > PostgreSQL. What's the equivalent or counterpart of MySQL's 'binary' > data type?
I have never used that datatype. If it's a blob type data structure, you can use text, I think. Note that the following m2p.pl script does not convert those. > Any scripts you can recommend for faster migration from one to the > other. I tried my2pg Perl script but it seems limited, it reported > error after some time. http://www.michaelchaney.com/m2p.pl Also, general help in converting: http://www.michaelchaney.com/mysql-to-postgres.html Michael -- Michael Darrin Chaney [EMAIL PROTECTED] http://www.michaelchaney.com/ _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
