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