Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When importing an SQLite database into MySQL I have repeatedly encountered the problem that encrypted passwords (even when copied manually) do not work anymore. Everything else works fine, but all passwords have to be reset.

Does anyone know the reason and / or how I can avoid this?

share|improve this question
How did you write the passwords to the database in the first place? – Ignacio Vazquez-Abrams Aug 20 '13 at 11:38
LiveConfig ( ) provides a dump file directly after installation on debian. At first I thought it was a problem with the file and I reinstalled the server, but it happened again. So I thought it was a problem with LiveConfig. But my workmate, who followed the instructions (creating a dump and importing it into MySQL) at to migrate an OwnCloud SQLite database to MySQL encountered the exact same problem. We both would actually really need a solution. – David Aug 20 '13 at 11:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.