Django: convert an application from sqlite to mysql
Posted by jason on July 11, 2011, 6 a.m.
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 manage.py script to dump the data to a json file.
cd <django-project-dir>
python2 manage.py dumpdata <appname> > <appname>.json ...
Diagnosing Special Character Issues in Mysql
Posted by jason on June 15, 2011, 6:57 p.m.
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 ...