K
K
kommov2019-03-17 11:47:16
SQLite
kommov, 2019-03-17 11:47:16

No access to SQLite after error. How to cure?

I am not an expert in SQLite, and I encountered such a problem:
There was a Base.db database, for 150k rows . It was necessary to
add a new column to table table1, I tried to do this in DB Browser for SQLite, through modify the desired table. I added this column there, and after - everything hung. Later, I learned that with such actions, SQLite creates and overwrites the entire table again. The Base.db-journal file was created, and the process went on for a whole day until this file became the size of the base. I left the whole thing for the night, and in the morning I found that the db browser was closed, and the process was completed.
Base.db-journal is still in the base folder. Now, when opening the database, I get this:
5c8e08856fd50378193593.png
There is a lot of disk space, RAM too, I work from a server on Windows. Are there any ways to get around this and resurrect the base?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Viktor Solovyov, 2019-03-18
@Dreddsa

Encryption of the entire database has its disadvantages:
- overhead for encrypting any service information
- in case of damage to the database, the entire database can be thrown out.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question