Hello

You first have to decide, if you want to keep the V2 database layout with a lot of tables (IIRC 6 per user), or if you want to switch to the combined Layout with only a fixed set of tables.

If you keep the layout, you can use the mysql dump method.
but keep in mind, that you have to apply the mysql scripts in /usr/share/doc/sogo/ before starting SOGo V5 for the first time, namely:
sql-update-3.2.10_to_4.0.0-mysql.sh
sql-update-5.5.1_to_5.6.0.sh
sql-update-5.8.4_to_5.9.0.sh

I would not do that.
Instead I would use sogo-tool backup on V2.
Then create a new, empty database for V5 and switch to the combined Layout in sogo.conf.
Now you can use sogo-tool restore on V5.


Kind regards,
Christian Mack

Am 04.06.25 um 02:25 schrieb "David.M.Clark" ([email protected]):
Hi All,

Can't see too much on this one online.

With LAMP I normally do an mysqldump and then mysql restore the .sql file with migrations.

I have an existing v2 server on CentOS 6 going to Rocky Linux 9 and just wondering if there are any issues with importing ye olde database into the current new server MySQL setup? I am expecting for it not to work but just checking as the existing database will have all the accounts and other bits set up so may save time re-doing all users etc (Not too many users so no big problem).

Any tips, cautions, flat out "No" welcome.



--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung, Lehre, Infrastruktur
78457 Konstanz
+49 7531 88-4416

Attachment: smime.p7s
Description: Kryptografische S/MIME-Signatur

Reply via email to