Importing .SQLite file To Shared Hosting (MySQL, PostgreSQL)

1

Hello,

I was handed a website that includes a database. Database is in the format of a ".sqlite" file. My hoster support tells me my shared hosting account only has MySQL and PostgreSQL installed, and doesn't know how to import a database in the format I have.

Can somebody help out?

2

Exporting SQLite data to CSV:

Import CSV to MySQL:

https://dev.mysql.com/doc/refman/8.1/en/load-data.html

Import CSV to PostGreSQL:

SQLTeam is a Microsoft SQL Server site, we're not experts in SQLite, MySQL, or PostGres. If you get stuck you might find better answers on StackOverflow. I found a few answers there, but they covered different things than your question.

If you're feeling adventurous, you could conceivably host your SQLite file and still use it for your web app:

1 Like