Differences

This shows you the differences between two versions of the page.

--- db_curruption [2022/10/19 14:05] – admin
+++ db_curruption [2022/10/19 14:12] (current) – admin
@@ Line 2: / Line 2: @@
 If your interface is giving you an error like
+{{:bacc4ca152e2cd12e7a3cc7f4384ba9fc8cc4beb.png?400|}}
@@ Line 8: / Line 10: @@
 **Method 1**
-Restoring your backup database found in the folder 'urbackup' under your back-up directory. Stop the database and rename your old DB backup_server.db in /var/urbackup. copy the backup_server.db of your urbackup folder into the /var/urbackup folder and restart your DB.
+UrBackup Server creates nightly backups of its database per default. If the restore procedure fails you can restore those. Restoring your backup database found in the folder 'urbackup' under your back-up directory. Stop the database and rename your old DB backup_server.db in /var/urbackup. copy the backup_server.db of your urbackup folder into the /var/urbackup folder and restart your DB.
+Steps:
+   service urbackupsrv stop
+Create a backup of the damaged database files. Delete all files belonging to the databases:
+   backup_server.db,
+   backup_server.db-shm,
+   backup_server.db-wal,
+   backup_server_settings.db,
+   backup_server_settings.db-shm,
+   backup_server_settings.db-wal
+   (rm backup_server*)
+Copy the files from the urbackup folder in the storage directory (backup_server.db and backup_server_settings.db) and start UrBackup Server.
 **Method 2**
@@ Line 31: / Line 50: @@
    PRAGMA integrity_check;
 You can defragment the database (maybe this also fixes integrity issues) with:
@@ Line 46: / Line 65: @@
 Delete file backup_server.db.
-sqlite3 backup_server.db
+   sqlite3 backup_server.db
-.read export.sql
+   .read export.sql
+In most cases that should solve your issue.
 \\