Re: [sqlite] sqllite ddb from win to linux

2006-12-13 Thread Kees Nuyt
On Wed, 13 Dec 2006 20:33:29 +0100, you wrote:

>The page where this is documented :
>   http://www.sqlite.org/sqlite.html
>is quite hard to find, the only link i found is on the 
>   http://www.sqlite.org/download.html 
>page, next to the "Precompiled Binaries For Windows"
>sqlite-3_3_8.zip link. Which is very appropriate, but a bit
>modest ;)

Oops, there's another link on 
http://www.sqlite.org/quickstart.html
as well:
"Additional documentation is available here  "
-- 
  (  Kees Nuyt
  )
c[_]

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqllite ddb from win to linux

2006-12-13 Thread Martin Jenkins

[EMAIL PROTECTED] wrote:

Use "sqlite" to read an sqlite version 2 database.  Use "sqlite3"
to read a version 3 database.
Just a thought, but would it be worth detecting attempts to open v2 
databases with sqlite3 and printing "this database appears to be version 
2 and I'm version 3 so I can't open it" rather than "database corrupt"?


Martin


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqllite ddb from win to linux

2006-12-13 Thread Rob Coenen

Kees,

thanks this helped me a lot. It turned out the DB was actually in sqlite V2
so I did a

sqlite3 olddatabasefile .dump >transportfile

end then transported the transportfile in a ZIP (binary safe) to the Linux
machine
where I did a
sqlite newdatabasefile  wrote:


On Tue, 12 Dec 2006 19:25:16 +0100, you wrote:

>ok - I was trying to do somthing like this, but I could not find any
sample?

sqlite3 olddatabasefile .dump >transportfile
[transfer transportfile in binary mode]
sqlite3 newdatabasefile On 12/12/06, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
>>
>> "Rob Coenen" wrote,
>>
>>
>> > hello all,
>> >
>> > I have been using TRAC for Windows and I need to restore the TRAC
wiki
>> on
>> > a
>> > Linux machine.
>> >
>> > The integrated Trac WIKI is stored in a sqlite file, it seems as
sqlite
>> > version 3 (judging by opening the .db file with a HEX editor, the
header
>> > mentions sqlite 3).
>> >
>> > I can read the file on Window with sqlite but I cannot read the same
>> file
>> > when I copy it to my Linux machine. It says that the file is not a
>> > database
>> > or that it is encrypted.
>> >
>> > Any help here?
>> >
>> The first thing that comes to mind is to dump the database to text and
>> then,
>> open a new one in unix and import it.
>>
>> just thinking...
>>
>>
>>
>>
-
>> To unsubscribe, send email to [EMAIL PROTECTED]
>>
>>
-
>>
>>
--
  (  Kees Nuyt
  )
c[_]


-
To unsubscribe, send email to [EMAIL PROTECTED]

-




Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread John Stanton

Could be an FTP in ASCII mode copy problem.

[EMAIL PROTECTED] wrote:

"Rob Coenen" <[EMAIL PROTECTED]> wrote:


yes that is what I tried; I did use sqlite3
does not work. Any known problems on moving db files from Win to Linux?




SQLite database files are cross-platform.  They work on linux,
windows, mac, various embedded platforms, etc.  Byte order does
not matter either.

Perhaps the file was corrupted by whatever utility you used to 
"move" it from win to Linux?  Perhaps \n got converted to \r\n
or something. Can you compare the md5 checksum of the file 
before and after moving it?


--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread Kees Nuyt
On Tue, 12 Dec 2006 19:25:16 +0100, you wrote:

>ok - I was trying to do somthing like this, but I could not find any sample?

sqlite3 olddatabasefile .dump >transportfile
[transfer transportfile in binary mode]
sqlite3 newdatabasefile On 12/12/06, jose isaias cabrera <[EMAIL PROTECTED]> wrote:
>>
>> "Rob Coenen" wrote,
>>
>>
>> > hello all,
>> >
>> > I have been using TRAC for Windows and I need to restore the TRAC wiki
>> on
>> > a
>> > Linux machine.
>> >
>> > The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite
>> > version 3 (judging by opening the .db file with a HEX editor, the header
>> > mentions sqlite 3).
>> >
>> > I can read the file on Window with sqlite but I cannot read the same
>> file
>> > when I copy it to my Linux machine. It says that the file is not a
>> > database
>> > or that it is encrypted.
>> >
>> > Any help here?
>> >
>> The first thing that comes to mind is to dump the database to text and
>> then,
>> open a new one in unix and import it.
>>
>> just thinking...
>>
>>
>>
>> -
>> To unsubscribe, send email to [EMAIL PROTECTED]
>>
>> -
>>
>>
-- 
  (  Kees Nuyt
  )
c[_]

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread drh
"Rob Coenen" <[EMAIL PROTECTED]> wrote:
> yes that is what I tried; I did use sqlite3
> does not work. Any known problems on moving db files from Win to Linux?
> 

SQLite database files are cross-platform.  They work on linux,
windows, mac, various embedded platforms, etc.  Byte order does
not matter either.

Perhaps the file was corrupted by whatever utility you used to 
"move" it from win to Linux?  Perhaps \n got converted to \r\n
or something. Can you compare the md5 checksum of the file 
before and after moving it?

--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread Rob Coenen

ok - I was trying to do somthing like this, but I could not find any sample?

On 12/12/06, jose isaias cabrera <[EMAIL PROTECTED]> wrote:




"Rob Coenen" wrote,


> hello all,
>
> I have been using TRAC for Windows and I need to restore the TRAC wiki
on
> a
> Linux machine.
>
> The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite
> version 3 (judging by opening the .db file with a HEX editor, the header
> mentions sqlite 3).
>
> I can read the file on Window with sqlite but I cannot read the same
file
> when I copy it to my Linux machine. It says that the file is not a
> database
> or that it is encrypted.
>
> Any help here?
>
The first thing that comes to mind is to dump the database to text and
then,
open a new one in unix and import it.

just thinking...



-
To unsubscribe, send email to [EMAIL PROTECTED]

-




Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread Rob Coenen

yes that is what I tried; I did use sqlite3
does not work. Any known problems on moving db files from Win to Linux?

On 12/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


"Rob Coenen" <[EMAIL PROTECTED]> wrote:
> hello all,
>
> I have been using TRAC for Windows and I need to restore the TRAC wiki
on a
> Linux machine.
>
> The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite
> version 3 (judging by opening the .db file with a HEX editor, the header
> mentions sqlite 3).
>
> I can read the file on Window with sqlite but I cannot read the same
file
> when I copy it to my Linux machine. It says that the file is not a
database
> or that it is encrypted.
>
> Any help here?

Use "sqlite" to read an sqlite version 2 database.  Use "sqlite3"
to read a version 3 database.
--
D. Richard Hipp  <[EMAIL PROTECTED]>



-
To unsubscribe, send email to [EMAIL PROTECTED]

-




Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread jose isaias cabrera



"Rob Coenen" wrote,



hello all,

I have been using TRAC for Windows and I need to restore the TRAC wiki on 
a

Linux machine.

The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite
version 3 (judging by opening the .db file with a HEX editor, the header
mentions sqlite 3).

I can read the file on Window with sqlite but I cannot read the same file
when I copy it to my Linux machine. It says that the file is not a 
database

or that it is encrypted.

Any help here?

The first thing that comes to mind is to dump the database to text and then, 
open a new one in unix and import it.


just thinking...


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] sqllite ddb from win to linux

2006-12-12 Thread drh
"Rob Coenen" <[EMAIL PROTECTED]> wrote:
> hello all,
> 
> I have been using TRAC for Windows and I need to restore the TRAC wiki on a
> Linux machine.
> 
> The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite
> version 3 (judging by opening the .db file with a HEX editor, the header
> mentions sqlite 3).
> 
> I can read the file on Window with sqlite but I cannot read the same file
> when I copy it to my Linux machine. It says that the file is not a database
> or that it is encrypted.
> 
> Any help here?

Use "sqlite" to read an sqlite version 2 database.  Use "sqlite3"
to read a version 3 database.
--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] sqllite ddb from win to linux

2006-12-12 Thread Rob Coenen

hello all,

I have been using TRAC for Windows and I need to restore the TRAC wiki on a
Linux machine.

The integrated Trac WIKI is stored in a sqlite file, it seems as sqlite
version 3 (judging by opening the .db file with a HEX editor, the header
mentions sqlite 3).

I can read the file on Window with sqlite but I cannot read the same file
when I copy it to my Linux machine. It says that the file is not a database
or that it is encrypted.

Any help here?