How to Migrate from SQLite DB to MySQL?

Why using SQLite as DB engine during tests fails in django?

• When I switch to mysql everything will work fine as expected .But when I change db to sqlite it throws me errors.

• Answer:

  Are you using South? In the more recent versions it runs migrations during tests unless explicitly disabled in http://settings.py, and some types of migrations that work for most RDBMSes will fail with SQLite. http://south.aeracode.org/docs/unittests.html http://seanhayes.name/2010/01/09/cross-database-incompatibility/