On Mon, 12 Oct 2020 at 13:39, Götz Reinicke <users@sogo.nu> wrote:

> Hi,
>
> what are the right steps to migrate the SOGo database to a new database
> server (with new server name):
>
> - dump/backup all user data
> - shutdown sogo
> - add a new database to the new server
> - edit the sogo.conf database serve name/user/password
>

It's easier to just reuse the creds from sogo.conf so no need to edit
sogo.conf (dbname, username, password):
MySQL>CREATE USER 'username'@'hostname OR IP' IDENTIFIED WITH
mysql_native_password BY 'the_password';
MYSQL>GRANT ALL ON dbname.* TO  'username'@'hostname OR IP';

- restart sogo
> - restore the user data from the backup
>
> Did I miss something?
>

Yes. move the dump to the new server :-)


>
> Are there known problems with the DB version upgrade?
>

I did not encounter any when I migrated from 5.7 to 8.0.


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Reply via email to