...
Maybe the import/export procedure skips some tables because of errors. In this case you either have to create them manually (Use .tables and .schema to find the commands to create them) or copy the existing data to a non-corrupt Database.
UrBackup Server 1.3 also includes a procedure that automatically does the import/export.
On Linux use the command:
start_urbackup_server --repair_database
On Windows use
repair_database.bat
UrBackup Server creates nightly backups of its database per default. If the restore procedure fails you can restore those. Steps:
- Stop UrBackup Server
- 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
- Start UrBackup Server