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

More
3 years 8 months ago #105401 by kettner
kettner created the topic: Restoring database from backup in order to migrate db to a new server...
Hello,

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.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!