StephanK
(Stephan Koenig)
April 17, 2020, 3:33pm
1
Stupid mistake. Deleted a private contact group with 50 contacts by mistake.
I have a full backup. Any way I can restore all contacts only. I cannot lose the text messages from today.
Or at least how to access them so I can print them and reenter.
Thanks for your help.
lgaetz
(Lorne Gaetz)
April 17, 2020, 3:51pm
2
The data is all stored in SQL in the tarball, but it’s spread across many tables:
MariaDB [asterisk]> show tables like "contactmanager%";
+--------------------------------------+
| Tables_in_asterisk (contactmanager%) |
+--------------------------------------+
| contactmanager_entry_emails |
| contactmanager_entry_images |
| contactmanager_entry_numbers |
| contactmanager_entry_speeddials |
| contactmanager_entry_userman_images |
| contactmanager_entry_websites |
| contactmanager_entry_xmpps |
| contactmanager_group_entries |
| contactmanager_groups |
+--------------------------------------+
9 rows in set (0.01 sec)
In your place I would prob spin up a quick and dirty VM and restore the backup, then bulk export the missing contacts to bulk import back in.
1 Like
StephanK
(Stephan Koenig)
April 17, 2020, 4:31pm
3
Thanks. Great idea.
Does the restore overwrite the machines IP address? If so, how do I manually change it to avid the conflict with the “old” machine?
lgaetz
(Lorne Gaetz)
April 17, 2020, 4:32pm
4
No. But if you’re not careful, it will re-register your trunks which can cause a conflict with your production system. Immediately delete/disable post restore.
StephanK
(Stephan Koenig)
April 17, 2020, 10:13pm
5
I was able to restore the contacts! Thank you so much for your help!
1 Like
StephanK
(Stephan Koenig)
April 18, 2020, 11:19am
6
Is there an easy way to (temporary) disable the trunks? I can not switch them off, as they are in use. So I would have to delete them from the routes, but that is not easy to restore.
StephanK
(Stephan Koenig)
April 19, 2020, 3:52am
7
Found it.
fwconsole trunks
and
fwconsole trunks --disable N
works.
system
(system)
Closed
May 20, 2020, 3:52am
8
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.