Django: Merge databases for same app

Question

I have the same django app running on two servers, each has its own local database. I want to migrate to a single server, again with a local database.

What's the easiest way to populate the new database with the models data of the old databases without losing references between models? (primary keys issues etc...)

Answer 1

there's always the dump data from django, which is pretty easy to use.

or you could do this manually:

• if the 2 databases share the same data (they are mirror one to another) and the same table structure, you could just run a syncdb from django to create the new table structure and then dump and import (i'm assuming you're using mysql, but the general idea is the same) the old database into the new one

• if the two databases share different data (still with the same structure) you should import every single row of the two databases: this way, you'll keep relations etc, but you'll have your unique id updated to the new sole db.

• if the two databases are different in both data and structure, you'll have to run two sincdb and two imports, but this doesn't seem to be your case

This is a reference to MySQL dump command