Database Switcheroo

Switching the database is quite fun with Django. In my case I’m slowly migrating my sites from MySQL to Postgres.

  1. manage dumpdata will produce a database independent XML or JSON dump
  2. manage syncdb will take care of producing a almost empty database skeleton
  3. the tables auth_permission and djangocontenttype in the database sekelton need to be cleaned completely
  4. manage loaddata reads the data from the dump and writes it back into the your new database