Migration path from nightly builds to Kopano ONE

stan23

Hi,
I’ve been using Zarafa community edition and Kopano nightly builds for more than 10 years for myself and my family, and end of last year I took the decision to buy a subscription.

However, since end of last year there’s this statement:

How can I switch from Kopano Groupware to Kopano ONE?
We are currently working on a migration path from existing Kopano Groupware installations to Kopano ONE. Please note that special requirements (everything besides directory on the same system) do apply to Kopano ONE.
source: https://kopano.com/products/groupware/one/

Can this be expected anytime soon?

My setup is a productive setup, but there are only few users and some outage or hickups during the migration are not too bad.
I would anyway want to test this migration (export/import) first on a VM.

Regards
Marco

fbartels

Hi @stan23,

that statement was more intended for current customers running Kopano 8.7 and wanting to do an in place upgrade to Kopano One, not specifically for users switching from the nightly builds.

It depends a bit on which version you are currently running. As long as the “database revision” matches between installations you can just import your mysql dump and will only need to clean out entries from the versions table that are higher than the currently installed one. The versions is also where you see which database revision your are currently on.

If the revision is higher on your current installation, than what it would be with Kopano One, then the easiest way to get your data over is to use kopano-backup to pull data from your current installation and restore it to the new one. You can even dp that from a single machine (I would recommend the target one) and just let kopano-backup remotely connect to the source system.

stan23

@fbartels Thanks Felix, your explanation perfectly makes sense.

I have installed kopano-server 10.0.6.687.

It took me some time to understand how to dump the versions table :-)
The last line shows revision as 118, right?
Would that work with Kopano ONE?

(6,30,0,15765,29,'2009-07-24 09:46:55'),
(6,30,0,16192,29,'2009-08-29 07:34:32'),
(6,30,0,17192,29,'2009-10-15 19:17:56'),
(6,30,0,17658,31,'2009-11-22 10:19:36'),
(6,30,0,18063,31,'2009-12-20 12:07:07'),
(6,30,0,18385,31,'2010-01-17 10:29:22'),
(6,30,0,18495,37,'2010-02-07 12:10:58'),
(6,30,0,18984,38,'2010-03-05 19:53:48'),
(6,30,0,20002,38,'2010-04-30 12:51:10'),
(6,40,0,20653,30,'2010-06-09 15:43:51'),
(6,40,0,20653,32,'2010-06-09 15:43:52'),
(6,40,0,20653,33,'2010-06-09 15:43:52'),
(6,40,0,20653,34,'2010-06-09 15:43:52'),
(6,40,0,20653,35,'2010-06-09 15:43:53'),
(6,40,0,20653,36,'2010-06-09 15:43:53'),
(6,40,0,20653,39,'2010-06-09 15:43:56'),
(6,40,0,20653,40,'2010-06-09 15:43:56'),
(6,40,0,20653,41,'2010-06-09 15:43:56'),
(6,40,0,20653,42,'2010-06-09 15:43:56'),
(6,40,0,22452,42,'2010-09-02 18:58:29'),
(6,40,0,23410,42,'2010-11-01 10:51:12'),
(6,40,0,24200,42,'2010-12-11 15:16:03'),
(6,40,0,26119,42,'2011-04-04 18:55:10'),
(7,0,0,27791,43,'2011-06-27 21:46:01'),
(7,0,0,27791,44,'2011-06-27 21:46:01'),
(7,0,0,27791,45,'2011-06-27 21:46:04'),
(7,0,0,27791,46,'2011-06-27 21:54:30'),
(7,0,0,27791,47,'2011-06-27 21:54:30'),
(7,0,0,27791,48,'2011-06-27 21:54:30'),
(7,0,0,27791,49,'2011-06-27 21:54:30'),
(7,0,0,27791,50,'2011-06-27 21:58:55'),
(7,0,0,27791,51,'2011-06-27 21:59:29'),
(7,0,0,27791,52,'2011-06-27 21:59:35'),
(7,0,0,27791,53,'2011-06-27 21:59:44'),
(7,0,0,27791,54,'2011-06-27 22:01:50'),
(7,0,0,27791,55,'2011-06-27 22:01:57'),
(7,0,0,27791,56,'2011-06-27 22:01:57'),
(7,0,0,27791,57,'2011-06-27 22:02:18'),
(7,0,0,27791,58,'2011-06-27 22:02:18'),
(7,0,0,31235,59,'2012-01-20 11:23:53'),
(7,0,0,31235,60,'2012-01-20 11:23:53'),
(7,0,0,31235,61,'2012-01-20 11:23:53'),
(7,0,0,31235,62,'2012-01-20 11:23:53'),
(7,0,0,31880,62,'2012-02-12 12:09:17'),
(7,0,0,34256,62,'2012-05-30 22:50:10'),
(7,1,0,34833,62,'2012-06-10 17:28:14'),
(7,1,0,36025,63,'2012-08-04 16:32:13'),
(7,1,0,40304,63,'2013-01-26 19:51:46'),
(7,1,0,42059,63,'2013-07-19 15:13:34'),
(7,1,0,42779,63,'2013-11-17 20:38:59'),
(7,1,0,44004,63,'2014-03-10 18:32:22'),
(7,1,0,44973,63,'2014-06-19 14:35:57'),
(7,1,0,45875,63,'2014-09-02 00:50:45'),
(7,2,0,657,64,'2016-06-12 22:40:46'),
(7,2,0,47017,63,'2014-12-31 15:41:09'),
(7,2,3,657,64,'2016-06-12 22:42:37'),
(7,2,4,14,64,'2016-06-13 18:03:44'),
(7,2,4,28,64,'2016-07-21 15:32:04'),
(7,2,4,29,64,'2016-07-21 16:32:54'),
(10,0,6,0,65,'2020-11-19 14:29:07'),
(10,0,6,0,66,'2020-11-19 14:29:07'),
(10,0,6,0,67,'2020-11-19 14:29:07'),
(10,0,6,0,68,'2020-11-19 14:29:07'),
(10,0,6,0,69,'2020-11-19 14:33:40'),
(10,0,6,0,70,'2020-11-19 14:33:40'),
(10,0,6,0,71,'2020-11-19 14:33:40'),
(10,0,6,0,118,'2020-11-19 14:33:40');

fbartels

@stan23 said in Migration path from nightly builds to Kopano ONE:

The last line shows revision as 118, right?

Yes, that is correct.

Here is the same table from my Kopano One testsystem:

root@felix-kopano-one:~# mysql -e "select * from kopano.versions"
+-------+-------+-------+----------+------------------+---------------------+
| major | minor | micro | revision | databaserevision | updatetime          |
+-------+-------+-------+----------+------------------+---------------------+
|     9 |     0 |     0 |        0 |              118 | 2020-11-27 15:01:19 |
|     9 |     0 |    12 |        0 |              118 | 2020-11-27 15:01:19 |
|     9 |     0 |    13 |        0 |              118 | 2020-12-22 15:25:08 |
+-------+-------+-------+----------+------------------+---------------------+
root@felix-kopano-one:~# dpkg -l | grep kopano-server
ii  kopano-server                                    9.0.13.0.1c83ba69f-0+debian10~17.1 amd64        Server component for Kopano Core