How to convert xxx.sql file to xxx.db and xxx.sqlite

I have some experience with MySQL and mobile device programming using apache cordova and phone gap.  I am just starting to work with databases using a plug in and I want to convert a MySQL database to a format that the plugin can read.  It sounds like it needs a .db format or a .sqlite format, and I am looking for tools that will perform the conversion.  I have my MySQL database exported as a .sql and .csv file, but I don't know what the .db or .sqlite formats are or how to convert them.

Thanks.  It is going to take awhile to figure out how all the plugins work and how the devices work.
LVL 5
sscottiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KRUNAL TAILORFreelance Mobile DeveloperCommented:
Hi sscotti,

Here is the list of converter.
http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

Let me know which tool helps you.

Thanks & Regards,
Krunal T. Tailor

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sscottiAuthor Commented:
Thank you for that.  I am kind of an OS X guy, but I have Windows in Parallels.  I opted for SQLite Data Wizard, but I'll go ahead and install a MySQL server on Windows 8 as well if it doesn't already come with it.

BTW, I am just learning how to use databases on SmartPhones.  Is the .db format the same as sqlite or are they different?  Seems like the iPhone uses sqlite.  I am exploring how best to import a database from an external server.  I could download an exported sqlite file and then copy it to a working database in the phone, or I could query the database from the phone app, probably via an ODBC connector using an intermediary server or same server PHP page.  Would that work?  Seems like it would quicker and more efficient to just download a file if they are not that dynamic (which they are not), and the files could be periodically updated when the database is updated.  Seems a lot easier to download 1 file rather than having to make database queries.

Thanks.

/sds
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Responsive Web

From novice to tech pro — start learning today.