Hi have a django project a full project now I want to migrate to mysql from the default Sqlite3 which is the default database. I am on a Mac OS and I don't know how to achieve this process. Any one with a complete guide on how to make the switch would be appreciated.
Go to your project's settings file and edit DATABASES with proper database connection
DATABASES = {'default': {'ENGINE': 'django.db.backends.mysql', 'NAME': 'DB_NAME','USER': 'DB_USER','PASSWORD': 'DB_PASSWORD','HOST': 'localhost','PORT': '3306',}
}
Now open mysql and create database as you give in DATABASE settings.
Go to your project -
./manage makemigrations
./manage migrate
This will create all the tables in the specified database name.