Reputation: 155
how can we import data in sqlite with a sqlite's txt file as a backup? Is it better to use a xml file?
Upvotes: 1
Views: 2995
Reputation: 21528
Maybe you mean to import a CSV file (Comma-Separated Values).
I suggest this way!
http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles
Upvotes: 0
Reputation: 5022
SQLlite database files are portable, there's no particular reason to dump them to text only to reimport them into a database except if you need something human-readable.
Upvotes: 1