Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: miglincit on July 14, 2025, 01:43:39 PM

Title: Database migration
Post by: miglincit on July 14, 2025, 01:43:39 PM
Hello,

I had to setup my server and during that I also updated to newer versions of all services...
E.g. Debian Buster (10) to Bookworm (12) aso.

And it that course I also installed Roundcube 1.6.5. from scratch.
I do have an SQL-Dump of the data of the previous installation and would like to know the easiest way to merge the data from the older version in to the new database. I am especially interested in restoring:

I did add/create some sub-folders (3) in the meanwhile, but those can be recreated if necessary.

Any help is appreciated
Thanks
Thomas
Title: Re: Database migration
Post by: SKaero on July 14, 2025, 02:53:58 PM
The easiest would be to update the old database, if you have merge the two databases it will be rather tricky.

To update the database you can either use the installer script that comes with Roundcube or do it manually by running the SQL files for each update that are in the SQL folder.
Title: Re: Database migration
Post by: miglincit on July 15, 2025, 02:48:36 AM
Can I just replace the current content of the identities table?
This would easen the update of the contacts a lot.
But this raises the question how users are identified and related to their identity...

Thomas
Title: Re: Database migration
Post by: SKaero on July 15, 2025, 10:19:34 AM
You would have to make sure the user ids match the correct user, you also may run into issues if the table structure has changed between releases.