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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

MySQL 2 SQLite Converter

Post 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 1275 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: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: MySQL 2 SQLite Converter

Post 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
With best regards,
Sudip
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: MySQL 2 SQLite Converter

Post 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
With best regards,
Sudip
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: MySQL 2 SQLite Converter

Post by Rathinagiri »

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: 109
Joined: Wed Aug 06, 2008 5:21 pm

Re: MySQL 2 SQLite Converter

Post 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
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: MySQL 2 SQLite Converter

Post 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
With best regards,
Sudip
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: MySQL 2 SQLite Converter

Post by Rathinagiri »

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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: MySQL 2 SQLite Converter

Post 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!
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: MySQL 2 SQLite Converter

Post 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
With best regards,
Sudip
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: MySQL 2 SQLite Converter

Post by Rathinagiri »

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