Re: [Astlinux-users] Writing to astdb.sqlite3

[Lonnie A. <li...@lo...>]

> On Jul 4, 2018, at 5:23 PM, Michael Knill <mic...@ip...> wrote:
> 
> Does anyone know if there is an issue with writing or deleting entries directly in the astdb.sqlite3 database rather than via Asterisk?
> It would only be used for backup/restore/factory reset purposes.

I would not do that if Asterisk is running.

If you need to change astdb.sqlite3 entries, do it via Asterisk.

As part of my tarsnap daily backups, my /mnt/kd/tarsnap-backup.script contains ...
--
sqlite3 /mnt/kd/astdb.sqlite3 .dump > "$CUSTOM_BACKUP_DIR/astdb.sqlite3.dump"
--
Ref: https://doc.astlinux-project.org/userdoc:tt_tarsnap_online_backup#optional_action_script

Then any restore would need to be done when Asterisk is not running.

Lonnie