i used sqlite for a social media project

I think for best practice, it's best you run everything from scratch. I think vue.js is an excellent choice, especially when you have to deal with follow, unfollow, messaging and others.

You need to shut the site down for a while and then you need to export every table into SQL and then run the migration on your MySQL server and then import table all the tables.

It's not as tricky as it sounds.

This tool might work as well

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

Thanks it's been a real pain. Will try this.

@tomasosho I don’t think you should be dishing out any “best practice” advice, given your question 😂

In answer to your question, you’re going to need to migrate to a “proper” relational database engine such as MySQL or Postgres. You’ll need to find a utility that converts a dump of your SQLite database to the database engine of your choice. Given you have 18 GB of data, I’m afraid this is probably going to occur quite a bit of downtime to prevent losing any data during the migration.

Lol... I was trying to do that, then I lost all my data, I just have a little piece left now though.

are there no free offline converters?

@tomasosho Mate, you’re not going to find a “free online converter” that’s going to convert an 18 GB SQlite database to nice MySQL import scripts for you.

Thanks, i was able to convert it offline.