Re: [sqlite] Converting Sqlite to Myqsl

[ben . carlyle]

- Forwarded by Ben Carlyle/AU/IRSA/Rail on 22/01/2004 11:13 AM -


Ben Carlyle
22/01/2004 11:06 AM


To: Martin Brinkmann <[EMAIL PROTECTED]>@CORP
cc: 
Subject:    Re: [sqlite] Converting Sqlite to Myqsl

Martin,





Martin Brinkmann <[EMAIL PROTECTED]>
22/01/2004 10:02 AM

 
To: [EMAIL PROTECTED]
cc: 
Subject:        [sqlite] Converting Sqlite to Myqsl


> I tried to find a easy way of converting the file to mysql format, i 
want 
> to use
> the data for a website of mine. Until now, i did not find a way to do it 

> and
> now i would like to ask you if you could provide me with an easy to 
> understand
> solution to this problem i face.

Have a look at the dump command on this web page:
http://sqlite.org/sqlite.html

The simple answer is
sqlite filename.idb .dump > sqlcommands.txt

sqlcommands.txt will contain the SQL commands required to re-create 
filename.idb using sqlite. You may need to edit the sqlcommands.txt to 
make sure the table columns have the correct types for mysql import.

Benjamin.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Converting Sqlite to Myqsl

[Martin Brinkmann]

Hello all,

this is my first post, i know a little php and mysql. Iam also using a 
program
which analyses ebay products. Unfortunatly it only exports the data i 
gather
as a Sqlite 2.1 Database file with the extension filename.idb

I tried to find a easy way of converting the file to mysql format, i want 
to use
the data for a website of mine. Until now, i did not find a way to do it 
and
now i would like to ask you if you could provide me with an easy to 
understand
solution to this problem i face.

I aldready downloaded sqlite and tried running it on my winxp command 
line, was able
to do so but i could not figure out how to export the file as a mysql one.

thanks for listening
Martin Brinkmann
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]