> Am 15.10.2020 um 17:30 schrieb Michael Hekeler (mich...@hekeler.com) > <users@sogo.nu>: > > On 12.10.20 16:00, Götz Reinicke wrote: >> (...) >> 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. > > When dumping your database with mysqldump then there is no hostname of > the database server in the dump because the hostname is set when > mysqldump establishes the connecion, e.g. `mysqldump -h hostname dbname` > > So you are safe to import this dumpfile on another host.
But in the sogo database there is the for some entries the database URL saved, which is set in the sogo.conf. So dumping the database on host „mysql-server01“ and importing it at „new-mysqlserver“ will break all entries! This would only work, if the database server dose not has an other name. (I should have created an DNS alias for it in the past) Regards . Götz
smime.p7s
Description: S/MIME cryptographic signature
