On 5 oct, 01:06, dmag...@xxxxxxxxx (Chris) wrote: > Jeff Lanzarotta wrote: > > Hello, > > > I have a MySQL dump file that I would like to import into our PostgreSQL > > 8.2 database. Is there a way to do this? > > You'll need to convert the table definitions then the data. > > For example, mysql has int(11) columns, postgres only has int columns. > > I usually convert the tables, then do a csv dump from mysql: > > select * from table into outfile '/path/to/file'; > > then import into postgres: > > \copy table from '/path/to/file' > > -- > Postgresql & php tutorialshttp://www.designmagick.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend hi! but what happens when somebody sent you a dump file and you can't convert the tables? all i have is a 116MB sql file, and i won't convert it by hand :P ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
