# Cannot migrate from doliwamp to postgres.

**URL:** <https://www.dolibarr.org/forum/t/cannot-migrate-from-doliwamp-to-postgres/17934>\
**Category:** Using my Dolibarr\
**Created:** [September 12, 2019, 6:51am UTC](https://www.dolibarr.org/forum/t/cannot-migrate-from-doliwamp-to-postgres/17934 "2019-09-12T06:51:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![navansh](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/f04885/32.png) [@navansh](https://www.dolibarr.org/forum/u/navansh)\
**Post date:** [September 12, 2019, 6:51am UTC](https://www.dolibarr.org/forum/t/cannot-migrate-from-doliwamp-to-postgres/17934/1 "2019-09-12T06:51:33Z")

</div>

Hi, I have tried to move from doliwamp to php7. I am using postgres and apache server. I have success with installing dolibarr on my machine with new setup. But I cannot restore the sql dump which I generated from dolibar 10 to migrate from sql to mysql. I tried restoring databes from command line as well restoring from pgadmin4 but it keeps on throwing errors. I have included my resimportlog. It show syntax errors. How can I fix this.

[resimport.log](https://www.dolibarr.org/forum/uploads/short-url/x663RCZfcQvnJzB4qhVxr3UXLu4.log) (15.1 KB)

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [September 12, 2019, 8:27am UTC](https://www.dolibarr.org/forum/t/cannot-migrate-from-doliwamp-to-postgres/17934/2 "2019-09-12T08:27:04Z")

</div>

Hi,

Doliwamp is using MYSQL and your online postgresql, you need to converter your backup : [https://wiki.postgresql.org/wiki/Converting\_from\_other\_Databases\_to\_PostgreSQL](https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL)

---

<div class="post-metadata">

**Author:** ![navansh](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/f04885/32.png) [@navansh](https://www.dolibarr.org/forum/u/navansh)\
**Post date:** [September 12, 2019, 2:20pm UTC](https://www.dolibarr.org/forum/t/cannot-migrate-from-doliwamp-to-postgres/17934/3 "2019-09-12T14:20:29Z")

</div>

This does not help I already made the dump from dolibarr with the options so that I can migrate from mysql to postgres.

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [September 12, 2019, 3:44pm UTC](https://www.dolibarr.org/forum/t/cannot-migrate-from-doliwamp-to-postgres/17934/4 "2019-09-12T15:44:59Z")

</div>

Hi,

It is clearly not ok `
ERROR: syntax error at or near "("
LINE 2: "rowid" int(11) NOT NULL,`

We can not help you more.

---

<div class="post-metadata">

**Author:** ![torvista](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/torvista/32/332_2.png) [@torvista](https://www.dolibarr.org/forum/u/torvista)\
**Post date:** [September 12, 2019, 3:48pm UTC](https://www.dolibarr.org/forum/t/cannot-migrate-from-doliwamp-to-postgres/17934/5 "2019-09-12T15:48:52Z")

</div>

Those errors indicate that the file you have created is expecting the database and the tables to already exist, which they do not.  
Do the dump/export again, selecting the option that creates a dump that creates the tables too.

---

<div class="post-metadata">

**Author:** ![navansh](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/f04885/32.png) [@navansh](https://www.dolibarr.org/forum/u/navansh)\
**Post date:** [September 12, 2019, 4:54pm UTC](https://www.dolibarr.org/forum/t/cannot-migrate-from-doliwamp-to-postgres/17934/6 "2019-09-12T16:54:29Z")

</div>

> [@torvista](#):
>
> Those errors indicate that the file you have created is expecting the database and the tables to already exist, which they do not.  
> Do the dump/export again, selecting the option that creates a dump that creates the tables too.

Thank you for your help. I will try it.