MySQL 2 SQLite Converter

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

Moderator: Rathinagiri

User avatar
Rathinagiri
Posts: 5126
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 112 times
Been thanked: 114 times
Birthday
Contact:

MySQL 2 SQLite Converter

Post by Rathinagiri » Sat Sep 19, 2009 2:52 am

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 696 times
For browsing SQLite database, I use http://www.sqlitebrowser.sourceforge.net
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
sudip
Posts: 1444
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 4 times

Post by sudip » Sat Sep 19, 2009 3:00 am

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
With best regards,
Sudip

User avatar
sudip
Posts: 1444
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 4 times

Post by sudip » Sat Sep 19, 2009 9:14 am

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
With best regards,
Sudip

User avatar
Rathinagiri
Posts: 5126
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 112 times
Been thanked: 114 times
Birthday
Contact:

Post by Rathinagiri » Sat Sep 19, 2009 11:04 am

Thank you Sudip for reviewing.

The application would create a .sql text file also (in SQLite syntax) in the destination directory!
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

gvaronas
Posts: 107
Joined: Wed Aug 06, 2008 5:21 pm

Post by gvaronas » Sat Sep 19, 2009 12:17 pm

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

User avatar
sudip
Posts: 1444
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 4 times

Post by sudip » Sat Sep 19, 2009 3:26 pm

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
With best regards,
Sudip

User avatar
Rathinagiri
Posts: 5126
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 112 times
Been thanked: 114 times
Birthday
Contact:

Post by Rathinagiri » Sat Sep 19, 2009 3:58 pm

But couldn't install it.
No. It is working fine.

Sudip, which Firefox version are you using?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
Rathinagiri
Posts: 5126
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 112 times
Been thanked: 114 times
Birthday
Contact:

Post by Rathinagiri » Sat Sep 19, 2009 4:02 pm

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!
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
sudip
Posts: 1444
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 4 times

Post by sudip » Sat Sep 19, 2009 4:04 pm

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
With best regards,
Sudip

User avatar
Rathinagiri
Posts: 5126
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 112 times
Been thanked: 114 times
Birthday
Contact:

Post by Rathinagiri » Sat Sep 19, 2009 4:15 pm

Mine is 3.5.3

You can double click or use tools -> add ons -> extensions or even file -> open
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

Post Reply