I'll try that next time. This time i found a cheat way around the problem. I used the sqlite command line program, which had no problems opening the database, and did a dump of the db. I then used the command line program to create a new db, and read in the dump file. Then i just swaped the problem db file with the one i just created.
Thanks for the help, Ian ---------- Forwarded message ---------- From: Steven Danneman <[EMAIL PROTECTED]> Date: Oct 20, 2006 6:05 PM Subject: Re: [sqlite] problems reading a sqlite db To: sqlite-users@sqlite.org It's possible that the end-of-line characters were converted when you transferred the DB file from Windows to Linux. This corrupts the binary format and can happen when you transfer a file over FTP in text mode. It's worth a shot to first run the DB file through the dos2unix command then try opening it on your Linux machine. -- Best regards, Steven Danneman <[EMAIL PROTECTED]> ITTIA - Mobile and Embedded Database Solutions Download a free evaluation of ITTIA DB at: http://www.ittia.com/community/request/ittiadb [EMAIL PROTECTED] wrote: > hi all, > > I'm trying to read a sqlite database that was created as part of a trac > installation. I'm running > ubuntu, python 2.3.4 and pysqlite2 > > I can read the db fine on a window server. > > When i copy the db over to our linux box though, i'm having some problems. > > I've written a very simple test script to try and open the db. When i run it, > i get an error when i > try to execute a SELECT statement. > > pysqlite2.dbapi2.OperationalError: unsupported file format > > As far as i can tell everything on the system is the latest version of both > pysqlite and sqlite. > I'm not really 100% sure how i can verify that though. > > Can anyone offer any suggestions as to how i would troubleshoot and resolve > this? > > thanks > > Ian > > > > > > ------------------------------------------------------------------------ > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
