title: Convert DB file to SQL or Excel
body: <p>I'd like to convert a .db file to .sql format. Even though, there are some problems. I've tried this command:  sqlite3 Zx.db .dump > ZX.sql. It has generated the sql file, but in the file I have the following:</p>
  
  <pre><code>  PRAGMA foreign_keys=OFF;
  
      BEGIN TRANSACTION;
      /**** ERROR: (26) file is encrypted or is not a database *****/
  
      ROLLBACK; -- due to errors
  </code></pre>
  
  <p>I've tried to see what it is in the original file with the geditor, but then it would give me a problem with the encoding. Also, I've tried open it in the MySQL workbench, but it also give me an "Unknown file encoding". Firstly, I want to know how to open this file, what software I'd use. But mainly, I'd like to know how to convert to sql file... I know that by the comment under the "begin transaction" this file can possibly not be a database... but it was required for me to convert it to a sql file.</p>