On Tue, 13 Oct 2020 at 00:05, Götz Reinicke 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 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
