How can I import an sqlite database to phpMyAdmin?

sqlite phpmyadmin mysql-error-1064
sanaEsprit picture sanaEsprit · Sep 5, 2013 · Viewed 23.4k times · Source

I have a sqlite database. I have tried to export that database and import it to phpMyAdmin in SQL format but it didn't work. Can someone please help me?

Answer

Martin Thoma picture Martin Thoma · Dec 30, 2013

You might want to take a look at phpliteAdmin. It looks like this:

enter image description here

You only need to be able to execute PHP. The whole project consists of 3 files, where one is a README, one is a config file and the other one is the real program.

Related questions

Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More
How to get a list of column names on Sqlite3 database?

I want to migrate my iPhone app to a new database version. Since I don't have some version saved, I need to check if certain column names exist. This Stackoverflow entry suggests doing the select SELECT sql FROM sqlite_master …

Read More