Just made a quick test here:
- created a new InfoLog with a delegation to user #213
- did a backup and inspected it with bzless --> search of egw_infolog_users a couple time to reach:
table: egw_infolog_users
info_res_id,info_id,account_id,info_res_deleted,info_res_modified,info_res_modifier,info_res_status,info_res_attendee
<<< skiped lines >>>
28,1065,"213",NULL,2019-09-24 07:39:42,5,"NEEDS-ACTION",NULL
Now restoring it into an other instance:
mysql egw_test1_dev
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 21663
Server version: 10.3.16-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [egw_test1_dev]> SELECT * FROM egw_infolog_users ORDER BY info_res_id DESC LIMIT 1;
+-------------+---------+------------+------------------+---------------------+-------------------+-----------------+-------------------+
| info_res_id | info_id | account_id | info_res_deleted | info_res_modified | info_res_modifier | info_res_status | info_res_attendee |
+-------------+---------+------------+------------------+---------------------+-------------------+-----------------+-------------------+
| 28 | 1065 | 213 | 0 | 2019-09-24 07:39:42 | 5 | NEEDS-ACTION | NULL |
+-------------+---------+------------+------------------+---------------------+-------------------+-----------------+-------------------+
1 row in set (0.000 sec)
So it works here …
Ralf
