Any way to access data from a backup?

[hackish]

Not sure why, but my hub stopped working a number of weeks ago. I see the following errors, and my devices list is empty, but some of the apps show the devices inside. I am seeing the following error:

java.lang.RuntimeException: java.sql.SQLException: Referential integrity constraint violation: "FK_3MWXSPUKB4E4KCTV44X4F153Q: PUBLIC.EVENT_SUBSCRIPTION FOREIGN KEY(DEVICE_ID) REFERENCES PUBLIC.DEVICE(ID) (CAST(360 AS BIGINT))"; SQL statement:
INSERT INTO event_subscription (version, filter, handler, name, installed_app_id, device_id, subscription_data) VALUES (1, ?, ?, ?, ?, ?, ?) [23506-224] Query: INSERT INTO event_subscription (version, filter, handler, name, installed_app_id, device_id, subscription_data) VALUES (1, ?, ?, ?, ?, ?, ?) Parameters: [1, allHandler, switch.on, 579, 360, 2] on line 8902 (method softUpdate)

I'm not sure if this was the result of an issue in a beta build, or something else. It's really not the end of the world if the data is not recoverable, it's just that I did fix a bunch of old rules, and it would be convenient to have them back.

[thebearmay]

Could restore from a backup if you have one available from before, but would lose any recent changes. Taking a swag at the error message I'd say the blank device table is the issue, sometimes a database rebuild will fix that without needing the restore from backup.

[hackish]

The database rebuild was not successful. Restoring from backup was, but I forgot to save a more up to date backup after my last rule cleanup. It's not the end of the world - I can suffer the rule editor every few years.