-->
Welcome, Guest
Username: Password: Remember me
You can also tweak your setup of Dolibarr by setting hidden configurations found in Dolibarr Setup Other

TOPIC: Cannot migrate from doliwamp to postgres.

Cannot migrate from doliwamp to postgres. 1 week 2 days ago #38442

  • navansh
  • navansh's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 3
  • Karma: 0
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.


File Attachment:

File Name: resimport.log
File Size: 15 KB
Last Edit: 1 week 2 days ago by ksar.
The administrator has disabled public write access.

Cannot migrate from doliwamp to postgres. 1 week 2 days ago #38445

  • ksar
  • ksar's Avatar
  • OFFLINE
  • Moderator
  • Posts: 322
  • Thank you received: 86
  • Karma: 14
Hi,

Doliwamp is using MYSQL and your online postgresql, you need to converter your backup : wiki.postgresql.org/wiki/Converting_from...abases_to_PostgreSQL
The administrator has disabled public write access.

Cannot migrate from doliwamp to postgres. 1 week 2 days ago #38451

  • navansh
  • navansh's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 3
  • Karma: 0
This does not help I already made the dump from dolibarr with the options so that I can migrate from mysql to postgres.
The administrator has disabled public write access.

Cannot migrate from doliwamp to postgres. 1 week 2 days ago #38454

  • ksar
  • ksar's Avatar
  • OFFLINE
  • Moderator
  • Posts: 322
  • Thank you received: 86
  • Karma: 14
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.
The administrator has disabled public write access.

Cannot migrate from doliwamp to postgres. 1 week 2 days ago #38455

  • torvista
  • torvista's Avatar
  • OFFLINE
  • Expert
  • Posts: 106
  • Thank you received: 25
  • Karma: 2
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.
Last Edit: 1 week 2 days ago by torvista.
The administrator has disabled public write access.

Cannot migrate from doliwamp to postgres. 1 week 2 days ago #38457

  • navansh
  • navansh's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 3
  • Karma: 0
torvista wrote:
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.
The administrator has disabled public write access.
Time to create page: 0.077 seconds