I'm using SQLite Manager for my project but sometimes all my tables disappear suddenly.
So what should I do for this?i'm confused because data in the table gone also.
Please help me..
Asked
Active
Viewed 1,449 times
-2
-
You'll have to show us some code so we can help. – IronSlug Jul 27 '15 at 14:44
-
1It could be a famous [copy local](http://stackoverflow.com/q/3167395/1997232) thing. You start software, create tables, but on the next start it's again empty, right? – Sinatr Jul 27 '15 at 14:56
-
@IronSlug it's not about the code. I think about setting database in the SQLite Manager but i don't know what's wrong. – Santi Rahayu Jul 28 '15 at 06:32
-
@Sinatr i don't know. i'm open again for several times and then my database empty. All my tables gone. – Santi Rahayu Jul 28 '15 at 06:38
-
@SantiRahayu Woops, my bad. IMO Doug Dawson has it right. – IronSlug Jul 28 '15 at 06:52
1 Answers
0
I found two links that might be of use.
Are you connecting to a database by name? If not by default the sqlite3 engine will create an in-memory database, and that will disappear once you disconnect.
http://forums.macrumors.com/threads/help-with-no-such-table-error-with-sqlite.1141918/
The second link is interesting because if you do reference a db file, but say your path is incorrect, the engine will create an empty file instead of returning an error.
If the database is opened (and/or created) successfully, then SQLITE_OK is returned.
I hope this helps!
Community
- 1
- 1
Doug Dawson
- 1,254
- 2
- 21
- 37
-
For reference in the my project, i don't add sqlite3 because it's error. I'm using .db for my database in the SQLite Manager. Which path is wrong? – Santi Rahayu Jul 28 '15 at 06:42
-
I'm not sure. I don't use SQLite Manager. I thought it was interesting, though, that if SQLite can't find the DB file, it creates a new, empty one. That might explain why the data and the tables are missing. – Doug Dawson Jul 28 '15 at 20:21