How to import .sql to .sqlite in mac [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 4 months ago.

Improve this question

Can anyone let me know how we can convert .sql database file into .sqlite file in mac.

Thanks in advance.

Hi Chris, yes it is a script with create and insert statements. — bawa
– bawa, Commented May 16, 2011 at 19:58
Hi Chris, no idea about DBMS as its given by client but .sql file have been generated through PHP Version: 5.2.4. Thanks. — bawa
– bawa, Commented May 16, 2011 at 20:19
Hi Chris, we looked into your link which you send the problem is the unique key as well as primary key we cant get these in our .sql file as it is encrypted. We want to ask for one more favour will it be possible for you to import the file if we send you the file. — bawa
– bawa, Commented May 16, 2011 at 21:48
This question is similar to: How to import load a .sql or .csv file into SQLite?. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — Bending Rodriguez
– Bending Rodriguez, Commented Aug 6 at 12:43

Bending Rodriguez · Accepted Answer · 2025-08-06 12:43:13Z

1

The way this is done depends on your DBMS, however generally speaking there are the following steps:

Create a Dump File out of your SQL-Database. A dump file contains all sql-statements needed to recreate that same SQL-Database on another machine.
Check if your source DBMS does contain SQL-Syntax not supported in SQLite. The documentation for SQLite https://sqlite.org/lang.html is the main source for this task. Notepad++ or other text editors are a helpful tool here. Also the moment you try to read in your MySQL-Dump in SQLite you will get an error traceback highlighting not supported keywords.
Craft the SQL-Dump so that it only contains SQL-Statements supported by SQLite.

Note that crafting portable SQL is a very hard and time consuming task and you might loose some functions compared to the source database.

edited Aug 6 at 12:43

answered Aug 6 at 11:52

Bending Rodriguez

1,3733 gold badges27 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to import .sql to .sqlite in mac [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related