Shifting From one Database To Another.

Working with databases may sometimes be tough when your database gets corrupted and you have to ditch it, you may also want to migrate from your existing database to a new database you have and you don’t want to lose data, this 5-minute tutorial should help.

 

HOW TO DUMP DATA INTO A JSON FILE BEFORE DELETING THE DATABASE AND CREATING A NEW DATABASE TO PLACE THE DUMPED DATA INSIDE.(WORKING WITH PYTHON AND SQLITE3 FOR THIS TUTORIAL)

1. New-Item -ItemType Directory -Force -Path backups (on powershell create a backups directory)
2. python manage.py dumpdata | Out-File -FilePath backups\data_backup.json(dump database data into a json file)
3. Remove-Item db.sqlite3(delete the existing database)
4. python manage.py migrate (create migrations which will make a new sqlite3 database, if you have not specified a new database yet)

     Check the Encoding of the JSON File

5. Open the data_backup.json file in a text editor that shows the encoding (e.g., VSCode, Notepad++).
6. Ensure that the file is saved with UTF-8 encoding. If it’s not, you can save it as UTF-8:
   1. In Notepad++: Open the file → go to Encoding → select UTF-8 → Save the file.
   2. In VSCode: Open the file → click the encoding (usually displayed at the bottom-right) → select Save with Encoding → choose UTF-8.

 

7. python manage.py shell (open the python shell)
8. from django.contrib.contenttypes.models import ContentType (command 1)
9. ContentType.objects.all().delete()  (command2)
10. exit()(command 3 to leave the shell)
11. python manage.py loaddata backups/data_backup.json (upload the data that you dumped into JSON into your new databse)

Hope This Helps, END.