From the course: Master Next.js by Building Scalable Apps with Routing, Databases, and Performance

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Database migration from SQLite to MySQL

Database migration from SQLite to MySQL - Next.js Tutorial

From the course: Master Next.js by Building Scalable Apps with Routing, Databases, and Performance

Start my 1-month free trial Buy for my team

Database migration from SQLite to MySQL

“

In the previous lecture, we have created the GitHub repositories for the admin, as well as the client app. Now we will deploy our site on the Vercel. But Vercel has a limitation that it does not support SQLite databases. We need to host the database on a separate server. And thus, we will use the server based database that is MySQL. To host the MySQL database, I'll be using a server space that I have on GoDaddy. GoDaddy is a platform where you can have or manage your own server space and domains. There are many such platforms, for example, Hostinger, BigRock, etc. So first of all, we are going to create a database on the server that is the server space on GoDaddy. Then we will migrate our existing SQLite database to MySQL database and host it on the server. Let's begin. First of all, we will create a MySQL database in GoDaddy. So let me open GoDaddy.com. I already have an account on GoDaddy. You may have to create an account and get server space for yourself. Now I will click on the…

Contents