Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

2020-10-28 Thread Michael Hekeler
On 15.10.20 22:04, Götz Reinicke wrote: > But in the sogo database there is the for some entries the database URL saved, > which is set in the sogo.conf. Oh. Didn't know that. Sorry. > So dumping the database on host „mysql-server01“ and importing it at > „new-mysqlserver“ will break all entries

Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

2020-10-16 Thread mj
On 10/15/20 10:04 PM, Götz Reinicke (goetz.reini...@filmakademie.de) wrote: 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

Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

2020-10-15 Thread goetz.reini...@filmakademie.de
> Am 15.10.2020 um 17:30 schrieb Michael Hekeler (mich...@hekeler.com) > : > > 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 wi

Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

2020-10-15 Thread Michael Hekeler
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 host

Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

2020-10-13 Thread Odhiambo Washington
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 databa

Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

2020-10-12 Thread goetz.reini...@filmakademie.de
Hi, > Am 12.10.2020 um 13:47 schrieb Odhiambo Washington (odhia...@gmail.com) > : > > > > 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

Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

2020-10-12 Thread Odhiambo Washington
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 na

[SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8

2020-10-12 Thread goetz.reini...@filmakademie.de
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 - restart sogo - restore the user data from the bac