Page 1 of 2

MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 2:52 am
by Rathinagiri
Hi,

Here is a primitive level software to convert a MySQL DB to a SQLite DB. Don't expect a perfect one!

I had added primary key only. As for as other unique and index keys, I am just working on that. :)

Tell me about your comments, suggestions and improvements.
mysql2sqlite.zip
(4.8 KiB) Downloaded 1278 times
For browsing SQLite database, I use http://www.sqlitebrowser.sourceforge.net

Re: MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 3:00 am
by sudip
Hello Rathi,

Thanks a lot for this software. :)

Right now I don't have MySql installed in my computer :( (for some technical reason). I shall install it and confirm you after testing. :)

Thanks again for this beautiful utility.

With best regards.

Sudip

Re: MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 9:14 am
by sudip
Rathi,

Thanks a lot. I tested it. It runs fine :)

Today I first tried to install MySql 5.1 but my NAV didn't allow it run :(

Then I tried with Easy PHP 3. Finally I can manage to run MySql. Then I tested your software.

Thanks again for the excellent utility.

With best regards.

Sudip

Re: MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 11:04 am
by Rathinagiri
Thank you Sudip for reviewing.

The application would create a .sql text file also (in SQLite syntax) in the destination directory!

Re: MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 12:17 pm
by gvaronas
Hello Rathi,

For browsing SQLite database, can test:
http://code.google.com/p/sqlite-manager/

Is very good!!!

BestRegards
GVS

P.D.: Sorry for my bad english

Re: MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 3:26 pm
by sudip
Rathi,
I was browsing the codes of your project. Excellent! :)
These will be very much helpful for anybody working with MySql and Sqlite.

GVS,
I downloaded Sqlite Manager (SQLiteManager_0.5.2b3.xpi). But couldn't install it.

Regards.
Sudip

Re: MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 3:58 pm
by Rathinagiri
But couldn't install it.
No. It is working fine.

Sudip, which Firefox version are you using?

Re: MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 4:02 pm
by Rathinagiri
gvaronas wrote:Hello Rathi,

For browsing SQLite database, can test:
http://code.google.com/p/sqlite-manager/

Is very good!!!

BestRegards
GVS

P.D.: Sorry for my bad english
Thanks a lot GVS. It is really good enough!

Re: MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 4:04 pm
by sudip
rathinagiri wrote:
But couldn't install it.
No. It is working fine.

Sudip, which Firefox version are you using?
Ver 3.0.14. Please help me how to install this.
Regards.
Sudip

Re: MySQL 2 SQLite Converter

Posted: Sat Sep 19, 2009 4:15 pm
by Rathinagiri
Mine is 3.5.3

You can double click or use tools -> add ons -> extensions or even file -> open