How to import an .sql file into a Postgres database?

Question

When I run the following command to import the sql DB into PostgreSQL,

psql -U homestead -h localhost <DB Name> < <backup.sql>

it throws the following syntax error.

ERROR:  unrecognized configuration parameter "sql_mode"
ERROR:  unrecognized configuration parameter "time_zone"
ERROR:  syntax error at or near "`"
LINE 1: CREATE TABLE IF NOT EXISTS `addresses` (

Any idea to resolve this issue. Thanks in advance.

There are some small differences in syntax between mysql and postgresql. You will find lots of help while searching mysql to postgresql — devanand
– devanand, Commented Mar 17, 2016 at 9:20

Isky · Accepted Answer · 2016-03-17 10:04:59Z

2

You can simply use mysqldump to create your .sql file.
mysqldump -u username -p --compatible=postgresql databasename > outputfile.sql
Now you can import .sql in your postgresql database without any error.
Hope this help.

answered Mar 17, 2016 at 10:04

Isky

1,3982 gold badges15 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to import an .sql file into a Postgres database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related