What’s the best way to migrate a Django DB from SQLite to MySQL?

by

Execute:

python manage.py dumpdata > datadump.json

Next, change your settings.py to the mysql database.

Finally:

python manage.py loaddata datadump.json

More Related Contents:

  1. Quick easy way to migrate SQLite3 to MySQL? [closed]
  2. Export a MySQL Database to SQLite Database
  3. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  4. Reorder / reset auto increment primary key
  5. MySQL Trigger after update only if row has changed
  6. MySQL Query to select data from last week?
  7. Select last N rows from MySQL
  8. Migrate from Oracle to MySQL
  9. How can I modify the size of column in a MySQL table?
  10. MySQL InnoDB foreign key between different databases
  11. How to insert data to MySQL with auto-incremented column(field)?
  12. How to design a multi tenant mysql database
  13. SQL Order By Count
  14. Replace Into Query Syntax
  15. What resources exist for Database performance-tuning? [closed]
  16. How to connect to MySQL from the command line
  17. Remote connect to clearDB heroku database
  18. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  19. MySQL foreign key to allow NULL?
  20. How to schedule a stored procedure in MySQL
  21. How do I split the output from mysqldump into smaller files?
  22. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  23. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  24. Where does MySQL store database files on Windows and what are the names of the files?
  25. Should I normalize my DB or not?
  26. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  27. How to Get True Size of MySQL Database?
  28. What are the max number of allowable parameters per database provider type?
  29. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  30. MySQL: Computed Column

Leave a Comment