Django MySQL database backup and restore to new server

[marc bellazzini]

Hello, 

I have Django 2.x running on an old Ubuntu server with a MySQL database. I have installed a new Ubuntu 20.04 server on another machine with Django 3.x and MySQL. I would like to backup the old Django/mysql database and restore it on the new server. What is the best practice for doing this? 

Thanks

Marc

 

[marc bellazzini]

SOLVED

# after more extensive googling .....

ORIGINAL SERVER

- cd to your web project directory

- python manage.py dumpdata > db.json

NEW SERVER

- sftp db.json file to new server web project directory

- python manage.py migrate

- python manage.py shell

-- >> from django.contrib.contenttypes.models import ContentType

-- >> ContentType.objects.all().delete()

-- >> quit()

- sftp db.json file to new server web project directory

- python manage.py loaddata db.json

[mcaay]

Thanks a lot! Solved my 

django.db.utils.IntegrityError: Problem installing fixture ... duplicate key value violates unique constraint

problem :)