Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Restoring database from backup in order to migrate db to a new server...

Restoring database from backup in order to migrate db to a new server... 2 years 9 months ago #105401

  • kettner
  • kettner's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 11
  • Karma: 0

I have been trying to migrate installation of LS from one server to another. As far as the Postgres db transfer is concerned, I made a backup sql file using phppgadmin and also using the same tool I imported the db into a new server with Postgres installed. It went fine, however it seems that it doesn´t work for users and their passwords (maybe due to encryption). So I have not been able to login on admin account. Apparently, the table with passwords differ after sql import to the latter database.

Do I make any mistake in db transfers? How should I proceed correctly? Is there any way to keep user passwords while importing the lime_users table via phppgadmin (importing sql backup script)?

As the same situation may happen when restoring db from backup may be needed for whatever reason, I am asking here, as it may be quite important.

Btw. I have tried to migrate the older 1.92+ version of LS.

Sorry if I have missed any relevant thread.

Many thanks for your help.
The administrator has disabled public write access.
Time to create page: 0.256 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form