How do I backl up the local DB?

Openfire Openfire Support
1

using Openfire 3.6.4…

how do i backup/export the LOCAL DB (ie internal openfire DB) and restore/import?

cheers

didds

2

if you are using mysql…use mysqldump

3

Do I need stop openfire while I do backup using mysqldump?

4

To answer the original question, one can simply copy the embedded-db folder to do a backup.

In both cases it is better to do a backup while Openfire is stopped, as it may have some information in the cache which is not yet flushed into database, so you might have incomplete backup if you do mysqldump while the server is running.

5

Thanks.

We are thinking to do daily or weekly external database backup as planified bacth process. Likely the users are not connected in those moment, but we prefer don´t stop Openfire.