title: Sqlite3 recreates empty database from dump file
body: <p>I have a problem with sqlite database. </p>
  
  <p>First of all, my database crashed somehow and whatever I'm trying to do with it, it says: "database disk image is malformed". It is probably because of I am writing huge texts with lots of "\n" to two columns in a table.</p>
  
  <p>So I've read a few topics here and on the other sites and I waneted to dump db and recreates it, but it said something like "the line is too long (max 1000 chars)" - now I cannot recreate this error. But the weird thing is that I am using 3.19.3 version of sqlite3, and I read on another thread here, that in the previous version, the problem with "\n" characters was resolved.</p>
  
  <p>Now the other approach of mine is that I looked into dump file and using regex toget rid of all of this texts. Now my dump file reduces its size from 750 Mb to 3,5 Mb. When I'm trying to recreate db from the new dump file and the old (this big one), the result is an empty file. A console does not provide any sort of result or error for me. So below I am posting my every step in the process.</p>
  
  <pre><code>sqlite3&gt; .open testDatabase.sqlite
  sqlite3&gt; .mode insert
  sqlite3&gt; .output dump.sql
  sqlite3&gt; .exit
  
  mv testDatabase.sqlite corruptDatabase.sqlite
  
  sqlite3&gt; .open testDatabase.sqlite
  sqlite3&gt; .read dump.sql
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>*gets rid of huge text values*
  sqlite3&gt; .open testDatabase.sqlite
  sqlite3&gt; .read small_dump.sql
  </code></pre>
  
  <p>Both resulting in an empty testDatabase.sqlite file. As I mentioned before, there is no error, so I have no idea what is going on. </p>
  
  <p>Please help, I don't know what to do with this.</p>