On Tue, 13 Oct 2020 at 00:05, Götz Reinicke <users@sogo.nu> wrote: > Hi, > > Am 12.10.2020 um 13:47 schrieb Odhiambo Washington (odhia...@gmail.com) < > users@sogo.nu>: > > > > 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‘; > > > > true@credentials. I’m used to set new ones, so I can be 100% sure I’m > connecting to the new db. >
Okay. > - 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. > Yes. I meant the DB backup. > > By dumping the user data I was referring to the pogo-tool backup. May be I > was a bit confusing, or did misunderstand you. > I never had to do that because on my servers, there is nothing that sogo saves outside the DB. TBH, I have never used sogo-tool even once! -- 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
