Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I import an sqlite database to phpMyAdmin?

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?

like image 805
sanaEsprit Avatar asked Sep 05 '13 08:09

sanaEsprit


2 Answers

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.

like image 193
Martin Thoma Avatar answered Oct 16 '22 09:10

Martin Thoma


To import SQLite database into PHPMyAdmin, there are many online converters available online to convert an SQLite file to SQL. I used this one

https://www.rebasedata.com/convert-sqlite-to-mysql-online

like image 44
Abhi Avatar answered Oct 16 '22 08:10

Abhi