Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: 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... 7 Monate 4 Wochen her #105401

  • kettner
  • kettners Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 9
  • Karma: 0
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.
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.175 Sekunden
Donation Image