CODEWITHSUNDEEP
phpapacheunixsqlitepermissions
ts.
ts.

Reputation: 10709

sqlite journal file location

Curently sqlite is writing journal file in the same directory where is placed database file. It makes a problem with the directory permission (it has to be writable). Is there any method to force sqlite to write journal files in other directory?

Upvotes: 2

Views: 1624

Answers (2)

Ehtyar
Ehtyar

Reputation: 226

Setting the journal_mode to OFF or MEMORY should do the trick.

http://sqlite.org/pragma.html#pragma_journal_mode

Upvotes: 0

Benoit
Benoit

Reputation: 79215

No, but you can use PRAGMA journal_mode = PERSIST.

Upvotes: 2

Related Questions