Re: How to properly backup and restore the sqlite db?

[Lutz Mader]

Hello Daniel,
I had used M/Monit up to 3.7.3 on a MacOS only,
but I copied the mmonit/db and mmonit/conf folder only to a new system,
to move to a new system. Have a look to the server.xml file and check
some of the options/settings.

Miration of a Sqlitedb to a Postgres is supported by the migrate_db.sh
script in the mmonit/db folder.

A suggestion only,
Lutz


Am 08.09.23 um 23:36 schrieb Daniel Callister:
> Hi MMonit Team,
> 
> I'm attempting to migrate from Ubuntu 16 M/Monit v3.7.15 to Debian12
> v3.7.15. I finally got around to cancelling my ESM updates from Ubuntu and
> have a working server on Debian12 ready to start monitoring my 150+ hosts.
> 
> My question is: I've used sqlite3 to dump a backup of the existing db:
> 
>  sqlite3 /opt/mmonit/db/mmonit.db ".backup '/root/monitdb.db'"
> 
> and now I'd like to restore it back to the new production instance. Is this
> possible?
> 
> Sincerely,
> 
> Daniel Callister
> 
> Systems Administrator / DevOps Engineer
> 
> M  +1 (385) 208 3770
> 
> E   daniel.callister@netstock.co
> 
> 
> 
> <https://www.facebook.com/NetstockInv/>
> <https://www.linkedin.com/company/netstock/?viewAsMember=true>
> <https://twitter.com/NetstockInv>
> 
> www.netstock.com
> 
> Subscribe to the Inventory Mentor <http://www.netstock.co/subscribe>
> 
> 
> 
> 
> 
> 
> 
> Disclaimer
> 
> The views expressed in this email are, unless otherwise stated, those of
> the author and not of Netstock Holdings, Inc., its subsidiaries and its
> associates “the company” or its management. The information in this email
> is confidential and is intended solely for the addressee. Access to this
> email by anyone else is unauthorized. If you are not the intended
> recipient, any disclosure, copying, distribution or any action taken or
> omitted in reliance on this, is prohibited and may be unlawful. This should
> not be taken as legal advice. Whilst all reasonable steps are taken to
> ensure the accuracy and integrity of information and data transmitted
> electronically and to preserve the confidentiality thereof, no liability or
> responsibility whatsoever is accepted if the information is, for whatever
> reason, corrupted or does not reach its intended destination.
>