I need convert *.db or *.sql to *.sqlite

The situation is as follows .:

I am a total newbie to programming.

I have an iPhone 4. The file my WhatsApp chats (ChatStorage.sqlite) was damaged and could not recover by WhatsApp

Back up the file and in the PC.

I try open the file with any SQL browser and he sent me the error:

"SQLite Error 11:" The database disk image is malformed ""

After days of failed attempts, I managed to repair the file by following these steps:

http://ift.tt/1yrJ0Fo

In short, the process is the next: . 1. Convert the file *.sqlite to * .sql 2. I search and delete errors (The database disk image is malformed) with UltraEdit 3. Save the file (* .sql).

Now I have the file in *.db or *.sql. The database is fully repaired, I can read with:

"SQLite Admin" or "SQLite Browser"

The problem comes when I want to convert the file to * .sqlite (only recognize this format WhatsApp)

I tried importing the *.sql with SQLite Manager Firefox Extension, but I always throws errors:

"Failed to import 688,229 lines. Row numbers: 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25 , 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50 , 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75 , 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100 , 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125 , 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150 , 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175 , 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200 , 201, 202, 203, 204, 205, etc ... "

"Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE)"

I have tried to modify the file to achieve the conversion but it still fails:

EXAMPLES:

"BEGIN TRANSACTION; CREATE TABLE ZWABLACKLISTITEM (Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, INTEGER Z_OPT, ZJID VARCHAR); INSERT INTO "ZWABLACKLISTITEM" "

"BEGIN TRANSACTION; CREATE TABLE "ZWABLACKLISTITEM" (Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, INTEGER Z_OPT, ZJID VARCHAR); INSERT INTO "ZWABLACKLISTITEM" "

"CREATE TABLE ZWABLACKLISTITEM (Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, INTEGER Z_OPT, ZJID VARCHAR); INSERT INTO "ZWABLACKLISTITEM" "

"CREATE TABLE" ZWABLACKLISTITEM "(Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, INTEGER Z_OPT, ZJID VARCHAR); INSERT INTO "ZWABLACKLISTITEM" "

"CREATE TABLE" ZWAMESSAGEWORD "(Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, INTEGER Z_OPT,

ZMESSAGE INTEGER, ZWORD VARCHAR); INSERT INTO "ZWAMESSAGEWORD" VALUES (507462,9,1,119683, 'BBQ') "

The tables stay around the file.

SQLite Manager never creates tables, much less care about the content.

I searched other programs or commands from the SQLite console but I can't get convert the file to *.sqlite.

This file is 140 MB.

I need to convert the file *.db or *.sql in *.sqlite.

Please, help me. Thanks.