On Wed, Feb 17, 2010 at 11:51 PM, Andreas Weller <wel...@andreas-weller.de> wrote: > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
Hi, this may be a stupid question, but have you used the BINARY mode when downloading the file from the FTP? Best regards, Filip Navara _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users