Dotaz: Precteni souboru s databazi

[Matej Slegr]

Dobry den, mam tento soubor:

$ hexdump -C db.altech.sqlite.db
00000000  53 51 4c 69 74 65 20 66  6f 72 6d 61 74 20 33 00  |SQLite format 3.|
00000010  04 00 01 01 00 40 20 20  00 00 07 90 00 00 00 00  |.....@  ........|
00000020  00 00 11 d6 00 00 00 d4  00 00 00 7e 00 00 00 04  |...........~....|
00000030  00 00 00 00 00 00 00 00  00 00 00 01 00 00 00 00  |................|
00000040  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  |................|
*
00000060  00 00 00 00 05 00 00 00  03 03 f1 00 00 00 00 1d  |................|
00000070  03 fb 03 f6 03 f1 00 00  00 00 00 00 00 00 00 00  |................|
00000080  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  |................|
*
000003f0  00 00 00 00 12 13 00 00  00 0a 0b 00 00 00 08 06  |................|
00000400  0d 03 6c 00 02 03 47 00  03 47 03 90 00 00 00 00  |..l...G..G......|
...

Ten obsahuje dump cele databaze. Jak ho prosim mohu nejjednoduseji prevest na SQL nebo csv dump? Nebo z nej alespon nejakym zpusobem dostat vsechna data?

---

---

Odpovědi

[kaaja]

Podle hlavičky se jedná o sqlite databázi. Podívejte se na nějaké nástroje pro sqllite. Například toto http://www.sqlite.org/sqlite.html by mohlo pomoci.

[Käyttäjä 11133]

Ten soubor pochází se SQLite3, tedy pomocí příkazu sqlite

sqlite> .help
.databases             List names and files of attached databases
.dump ?TABLE? ...      Dump the database in an SQL text format
.echo ON|OFF           Turn command echo on or off

[Käyttäjä 11133]

Třeba:

sqlite> .mode csv
sqlite> .output test_file_1.csv
sqlite> select * from nejaka_tabulka;
sqlite> .exit

Tabulky zjistíš příkazem .tables