Django: convert an application from sqlite to mysql

Posted by jason on July 11, 2011, 6 a.m.
Tags: django mysql python sqlite

Thanks to Steve Lord for this one.

Here's how to take a local django application in sqlite and deploy it into a mysql production environment.

First, use django's script to dump the data to a json file.

cd <django-project-dir>
python2 dumpdata <appname> > <appname>.json ...

Diagnosing Special Character Issues in Mysql

Posted by jason on June 15, 2011, 6:57 p.m.
Tags: mysql sysadmin utf8

Any webmaster who deals with Mysql and some website that uses PHP has probably run into character encoding issues at some point. Whether it's a user copying and pasting from Microsoft Word and getting those "curly quotes", converting a database from latin1 to utf8, importing data from another source ...