Author Topic: Restoring of mysql dump  (Read 2691 times)

Offline Plenz

  • Newbie
  • *
  • Posts: 3
Restoring of mysql dump
« on: November 12, 2014, 05:04:57 AM »
Well... I created this account because I had troubles, but meanwhile found the solution already.
But perhaps somebody else may have the same problem, so I want to describe it.

I used mysqldump and saved my data base, then I upgraded my server to Debian Wheezy and installed new versions of all software.
I restored the database from the dump file, installed Roundcube - and there was nothing. No contacts, no identities.
I logged into my server, logged into mysql, looked into the Roundcube database - and there was everything!

I used Roundcube and created a new identity. I looked again into the Roundcube database, and there was the new identity!
And then I found the reason: there is a column "user_id" which was 2 for the new identity and 1 for the rest from the backup.

The rest was easy:

update identities set user_id = 2;
update contacts set user_id = 2;

and everything was shown in the Roundcube web menu!  ;D

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,882
    • SKaero - Custom Roundcube development
Re: Restoring of mysql dump
« Reply #1 on: November 12, 2014, 02:22:52 PM »
If you look in the users table you can see what changed between the accounts that caused the problem.