Import MySQL dump to PostgreSQL database

by

This question is a little old but a few days ago I was dealing with this situation and found pgloader.io.

This is by far the easiest way of doing it, you need to install it, and then run a simple lisp script (script.lisp) with the following 3 lines:

/* content of the script.lisp */
LOAD DATABASE
FROM mysql://dbuser@localhost/dbname
INTO postgresql://dbuser@localhost/dbname;


/*run this in the terminal*/
pgloader script.lisp

And after that your postgresql DB will have all of the information that you had in your MySQL SB.

On a side note, make sure you compile pgloader since at the time of this post, the installer has a bug. (version 3.2.0)

More Related Contents:

  1. How to filter SQL results in a has-many-through relation
  2. How to select the nth row in a SQL database table?
  3. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  4. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  5. Simulating MySQL’s ORDER BY FIELD() in Postgresql
  6. Simple Random Samples from a Sql database
  7. SQL: Repeat a result row multiple times, and number the rows
  8. Why do results from a SQL query not come back in the order I expect?
  9. Best practices for SQL varchar column length [closed]
  10. Relationship between catalog, schema, user, and database instance
  11. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  12. What resources exist for Database performance-tuning? [closed]
  13. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  14. Are SELECT type queries the only type that can be nested?
  15. how to cast the hexadecimal to varchar(datetime)?
  16. Postgres LEFT JOIN with WHERE condition
  17. How do you write a case insensitive query for both MySQL and Postgres?
  18. Foreign key to one of many tables?
  19. What are the max number of allowable parameters per database provider type?
  20. What happens when I exhaust a bigint generated key? How to handle it?
  21. Error related to only_full_group_by when executing a query in MySql
  22. Can you split/explode a field in a MySQL query?
  23. MySQL Cannot Add Foreign Key Constraint
  24. Grouping into interval of 5 minutes within a time range
  25. Difference between float and decimal data type
  26. Parse date in MySQL
  27. mysql dynamic query in stored procedure
  28. How to select one row randomly taking into account a weight?
  29. Array data type, split string,
  30. How can I make a table in MySQL called “order”?

Leave a Comment