Hi, > Am 12.10.2020 um 13:47 schrieb Odhiambo Washington ([email protected]) > <[email protected]>: > > > > On Mon, 12 Oct 2020 at 13:39, Götz Reinicke <[email protected] > <mailto:[email protected]>> 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‘;
true@credentials. I’m used to set new ones, so I can be 100% sure I’m connecting to the new db. > > - restart sogo > - restore the user data from the backup > > Did I miss something? > > Yes. move the dump to the new server :-) I guess you talk about the database dump? As the database server name will change, I can’t use the „old“ dump anymore I think. By dumping the user data I was referring to the pogo-tool backup. May be I was a bit confusing, or did misunderstand you. > > > Are there known problems with the DB version upgrade? > > I did not encounter any when I migrated from 5.7 to 8.0. Good to hear. thx. Regards. . Götz
smime.p7s
Description: S/MIME cryptographic signature
