SQLite3 database or disk is full / the database disk image is malformed

by

To repair a corrupt database you can use the sqlite3 commandline utility. Type in the following commands in a shell after setting the environment variables:

cd $DATABASE_LOCATION
echo '.dump'|sqlite3 $DB_NAME|sqlite3 repaired_$DB_NAME
mv $DB_NAME corrupt_$DB_NAME
mv repaired_$DB_NAME $DB_NAME

This code helped me recover a SQLite database I use as a persistent store for Core Data and which produced the following error upon save:

Could not save: NSError 259 in Domain
NSCocoaErrorDomain { NSFilePath =
mydata.db NSUnderlyingException =
Fatal error. The database at mydata.db
is corrupted. SQLite error code:11,
‘database disk image is malformed’ }

More Related Contents:

  1. Has Windows 7 Fixed the 255 Character File Path Limit?
  2. What is a sparse file and why do we need it?
  3. Why should text files end with a newline?
  4. Batch files: How to read a file?
  5. Inserting text into an existing file via Java
  6. Changing Vim indentation behavior by file type
  7. Trying to create a file in Android: open failed: EROFS (Read-only file system)
  8. Symfony2 file upload step by step
  9. Batch: Remove file extension
  10. How do I find files that do not contain a given string pattern?
  11. How to copy a file from one directory to another using PHP?
  12. How to limit the number of dropzone.js files uploaded?
  13. Powershell: Check if a file is locked
  14. batch file: list rar file in specific folder and write result into text file
  15. How do I move files in node.js?
  16. Can I simply ‘read’ a file that is in use?
  17. jQuery: read text file from file system
  18. How to find the largest file in a directory and its subdirectories?
  19. File Uri Scheme and Relative Files
  20. Download file from url, save to phones storage
  21. How do I find the current directory of a batch file, and then use it for the path?
  22. How to check if a file exists in Go?
  23. Process leaked file descriptors error on JENKINS
  24. What are the pros and cons of parquet format compared to other formats?
  25. Haskell file reading
  26. Windows 2008 R2 – Kernel (System Process PID=4) is locking files and folders
  27. Encrypt SQLite database in C#
  28. Is it possible to use threads to speed up file reading?
  29. How can I redirect stdout into a file in tcl
  30. CMake: reuse object files built for a lib into another lib target

Leave a Comment