Migrating django app from MySQL to Postgres_MySQL

Django

By :manjunath

in this tutorial, we will take a django app backed by mysql and will convert mysql database to postgres database. this is useful if we are deploying our app toherokubecauseherokuuses standardpostgres

Prerequisites:

• We assume that you have a running django app with MySQL as a database.
• Also, your app is running on virtualenv.

Converting MySQL to Postgres:

Let's assume that you have a django app running with MySQL and you want to convert this to Postgres.

1) Install dependenicies:

<code>$ pip install psycopg2$ pip install py-mysql2pgsql</code>

2) Create Postgres database:

<code>postgres@agiliq-Inspiron-N5010:~$ psqlpsql (9.1.11)Type "help" for help.postgres=# create database my_database;CREATE DATABASEpostgres=#</code>

3) Run:

<code>$ py-mysql2pgsql</code>

At initial run this command creates a file namedmysql2pgsql.ymlhaving the below info:

<code>mysql:hostname: localhostport: 3306socket: /tmp/mysql.sockusername: foopassword: bardatabase: your_database_namecompress: falsedestination:postgres:hostname: localhostport: 5432username: foopassword: bardatabase: your_database_name</code>

Update the above configuration file with appropriate database credentials for both 'MySQL' andPostgres.

4) Run:

<code>$ py-mysql2pgsql -v -f mysql2pgsql.yml</code>

The above command will transfer the data fromMySQLdatabase toPostgres.

Note:

• The above command may raise someIntegrityerrors, but no worries it can be fixed. :)
• You can also include or exclude some tables check thisHere

5) Be sure to update your databasesettings.pyfile:

<code>DATABASES = {"default": {	"ENGINE": "django.db.backends.postgresql_psycopg2",	"NAME": "your_database_name",	"USER": "your_username",	"PASSWORD": "your_password",	"HOST": "localhost",	"PORT": "5432",}}</code>

6) Verify the correctness by adding some data to your existing database(Postgres).

---

You can read all ofmanjunath's post, andfollow manjunath on Twitter

---

Can we help you build amazing apps?Contact us today.