Open link in a new tab

Content

Expand project menu

Import MySQL Backup -> internal error

Hello Community,

I have a problem with import my OpenProject Backup.
One year ago, the backup was created with the “openproject run backup” command.

Now, I want to import the backup to a fresh installation of openproject. What is the problem? I cannot login :-(

I detect the following behaviour:

If I try to login with a username, that isn’t included in the users-MySQL-Table, I will get a normal “Unknown username or bad password”-Hint.

If I try to login with an existing username, for example “admin”, I got for all passwords an “Internal error…”.

So my guessing is, OpenProject cannot “read” the user_passwords MySQL Table…

What is the right character set? How can I analyse my MySQL-Dump to find a solution? Any ideas to fix my dump???

I hope someone is able to help me :-)