Eli Mesika has submitted this change and it was merged. Change subject: core: database restore fixes ...................................................................... core: database restore fixes This patch enables restoring the database from a old backup and will perform all necessary data and schema updates using the upgrade.sh script that is executed after the restore is completed. The upgrade step also forces truncation of the async_tasks and business_entity_snapshot tables since those tables contain data that is relevant for asynchronous tasks and might lead to exceptions if restored. You can omit the execution of the upgrade step with the -o flag. The recommended way for restoring your database is. 1) backup current with backup.sh 2) run restore.sh and give other database instance name as the target 3) edit JBOSS standalone.xml to run the new restored database instance 4) verify that all tasks in the application are completed 5) restart JBOSS Change-Id: Ib2fc6b61e8e679db40acf2a074fc4737873d5707 Signed-off-by: Eli Mesika <emesika@redhat.com> --- M backend/manager/dbscripts/restore.sh 1 file changed, 15 insertions(+), 3 deletions(-) Approvals: Eli Mesika: Verified; Looks good to me, approved -- To view, visit http://gerrit.ovirt.org/5335 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ib2fc6b61e8e679db40acf2a074fc4737873d5707 Gerrit-PatchSet: 4 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Yair Zaslavsky <yzaslavs@redhat.com>