Geek asks and answers

How to remove -journal file without compromising the database?

I am using SQLite and a php application that runs in the background. I blocked the application using (Ctrl-c) and I just noticed that I have database.sqlite and database.sqlite-journal.

At the moment, how can I delete the -journal file without compromising the database?

Thank!

PS SQLite version 3.7.9

EDIT:

-rw-r--r--. 1 damiano damiano  51M  8 mar 18.15 test.sqlite2
-rw-r--r--. 1 damiano damiano 2,6K  8 mar 18.15 test.sqlite2-journal
[damiano@localhost backup]$ sqlite3 test.sqlite2
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> 
[damiano@localhost backup]$ ls -lh
-rw-r--r--. 1 damiano damiano  51M  8 mar 18.15 test.sqlite2
-rw-r--r--. 1 damiano damiano 2,6K  8 mar 18.15 test.sqlite2-journal
[damiano@localhost backup]$
+5
source share
2 answers

Run the following command:

sqlite3 test.sqlite2 vacuum

-journal ( ). , - ( / ), .

+9

( sqlite3). SQLite .

+1

More articles:


All Articles