asked on

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.

ASKER CERTIFIED SOLUTION

KRUNAL TAILOR

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sscotti

ASKER

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