how to setup mysql in python django project.

Hey!

Are you using the DigitalOcean App Platform? If this is the case, the best approach here would be to use a managed MySQL cluster.

Using SQLite with the App Platform is not recommended as the App Platform has ephemeral storage, meaning that any data you store on the App Platform itself locally, will be lost after each redeployment.

To set up MySQL in your Python Django project on DigitalOcean, and resolve the issue of empty tables when migrating, follow these steps:

1. Create a MySQL Cluster:

   • Follow the guide to create a MySQL cluster on DigitalOcean: Create a Managed MySQL Database
   • Note down the connection details (host, port, username, password, and database name).

2. Install Django MySQL Adapter:

   pip install mysqlclient
   

3. Update settings.py: Open your Django project’s settings.py file and update the DATABASES setting:

   DATABASES = {
       'default': {
           'ENGINE': 'django.db.backends.mysql',
           'NAME': 'your_database_name',
           'USER': 'your_mysql_user',
           'PASSWORD': 'your_mysql_password',
           'HOST': 'your_mysql_host',  # e.g., 'db-mysql-nyc3-12345-do-user-67890-0.b.db.ondigitalocean.com'
           'PORT': 'your_mysql_port',  # e.g., '25060'
       }
   }
   

   Replace your_database_name, your_mysql_user, your_mysql_password, your_mysql_host, and your_mysql_port with the details from your DigitalOcean Managed MySQL Database.

After that redeploy your project to the App Platform.

Let me know how it goes!

Best,

Bobby