How to repair the database files

From Multi Theft Auto: Wiki
Revision as of 22:05, 25 June 2011 by Ccw (talk | contribs) (Created page with "=Warnings= '''Backup all files before attempting a repair!''' <br> '''Shutdown the server before attempting a repair!''' =Windows server= ==Easy way== *Download [http://updates...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Warnings

Backup all files before attempting a repair!
Shutdown the server before attempting a repair!

Windows server

Easy way

  • Download this
  • Unzip and put the files into server/mods/deathmatch/
  • Double click on sqlite_repair_internal_db.bat to repair internal.db
  • Double click on sqlite_repair_registry_db.bat to repair registry.db

Hard way

  • Download sqlite-shell-win32 from here. If that link fails, the main download page is here.
  • Unzip and put sqlite3.exe into server/mods/deathmatch/
  • Open command prompt the change directory to server/mods/deathmatch/
  • To repair internal.db:
    • Copy internal.db to internal_original.db
    • Do this command: sqlite3.exe internal_original.db .dump | sqlite3.exe internal_repaired.db
    • Copy internal_repaired.db to internal.db
  • To repair registry.db:
    • Copy registry.db to registry_original.db
    • Do this command: sqlite3.exe registry_original.db .dump | sqlite3.exe registry_repaired.db
    • Copy registry_repaired.db to registry.db


Linux server

Only way

  • Download sqlite-shell-linux from here. If that link fails, the main download page is here.
  • Unzip and put sqlite3 into server/mods/deathmatch/
  • To repair internal.db:
    • Copy internal.db to internal_original.db
    • Do this command: ./sqlite3 internal_original.db .dump | ./sqlite3 internal_repaired.db
    • Copy internal_repaired.db to internal.db
  • To repair registry.db:
    • Copy registry.db to registry_original.db
    • Do this command: ./sqlite3 registry_original.db .dump | ./sqlite3 registry_repaired.db
    • Copy registry_repaired.db to registry.db