Backup kiwix website

[rgaudin]

Kiwix WP website is not automatically backed-up. We should create and deploy a small service that:

• dumps and backs up the MySQL database (cyon allows us to specify host names with remote access to the DB). alternatively, folder contains 4 daily dumps in sql.gz
• retrieve via scp/sftp (cyon allows connecting via ssh) and upload (to borgbase) the whole cyon folder.

Note: restoring WP is know to require attention as the DB contains references to paths and URLs.

[benoit74]

Should we directly use one of these plugins: https://wordpress.org/plugins/tags/backup/ ?

[rgaudin]

Not sure what those do but we need to upload to our borgbase account, using our bitwarden stack (https://github.com/kiwix/borg-backup/).

I doubt it can be done directly from within the plugin. Plugin could prepare it all for backup though.

borg-backup already takes care of DB backup and files backup though.

Probably worth looking at those plugin to understand what they do and if it's of value.

[kelson42]

It looks like we still have not automated solution and no test of restoration done. This is a problem in general... and a blocker considering we are about to fully revamp and launch 2 other WP sites.

[benoit74]

This will be done as part of #340