How to restore a database from a backup (bench backup & bench restore)?

[deatram]

When you do backup and restore in the same server, I guess it’s okay, you might not need an encryption key.

But when you do backup and restore on another different server, encryption key is required in order to decrypt the database. some functions won’t work in ERPNext unless you replace your encryption key with the original one from your previous server.

You can follow up some discussions like this

frappe.exceptions.ValidationError: Encryption key is invalid, Please check site_config.json

For us this was a sort of hidden requirement we didn’t even know the existence of the encryption keys in site_config.json and its dependency had we known that we would have certainly factored that into our solution. When a product says it has a backup solution and a restoral methodology one generally believes that the makers of the software know what they need and include everything necessary for a working restoral but in this case that was not true. We found a work around and hope it saves oth…

many people didn’t know even such thing even existed until they encountered an error after restore, and by then it had been too late because the original encryption keys were already lost.