Import sql dump file to sqlite

If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid. Related Questions. Sqlite save to database. Sqlite import to database with button click winform.

Convert query from SQL server to sqlite. How to create a local sqlite database and publish together to IIS? How to upgrade sqlite database on android app update for existing user without loosing data.

Sqlite database lock. Importing to a database. Layout: fixed fluid. Connect and share knowledge within a single location that is structured and easy to search. Here is my use case: I have an sql dump file provided by a server application that I don't have access to, neither to the MySQL database that originates the file. The sql dump file is an ordinary one, common base SQL syntax, as those generated by phpmyadmin.

I download this text file into an Android device. The columns are just of type 'int' or 'text', not other types. I want then to import this file into the Android app's SQLite database - basically reading the file into a stream, then executing one-by-one the sql statements.

Again, it's not about external tools. Do you have shell access? You could just cat file. Here is a good blog entry of how to do it in code.

If you have the MySQL-specific dialect to worry about, you'd either have to preprocess or modify it in the stream of work in code.

Because I faced this issue I think my findings and solution could be in the interest of others. Here it is:. This is basic but, believe me, it is the most appropriate for such functionality. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow.

You must run the migration until the migrated version that is active on the production database. Check the dump. The final step is importing the dump file. To do this we have to execute the following command within a terminal:. Of course you could also remove the lines from the file, but I prefer this way.