Hi.
Unfortunately my Webhosting provider ceased sqlite 2 support. I
downloaded the database file using FTP and tried to dump it on a debian
PC with sqlite 2.8.17

This resulted in the following error message:
> andr...@notebook:~/db$ sqlite ./database.db ".dump" 
> Unable to open database ./database.db

I had a look into it with hexdump:

> 2a 2a 20 54 68 69 73 20  66 69 6c 65 20 63 6f 6e  |** This file con|
>  74 61 69 6e 73 20 61 6e  20 53 51 4c 69 74 65 20  |tains an SQLite |
>  32 2e 31 20 64 61 74 61  62 61 73 65 20 2a 2a 00  |2.1 database **.|
>  28 75 e3 da 0f 08 00 00  01 00 00 00 23 00 00 00  |(u..........#...|
>  04 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  |................|
>  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  |................|

Is there any known problem with using sqlite 2.1 files with 2.8 version?

How to convert this version to sqlite 3?

Thank you!


Regards,
  Andreas Weller

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to