Re: [sqlite] Converting Sqlite to Myqsl
- 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
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]