[solved] Move django from SQLite to MySQL

When you start develop new site, you may run from little one with tiny database.
For django best start from sqlite and after some time, if you project begin grow you move to more serious database engine (MySQL, Postgre SQL etc).
Sadly, django does not have any ready tools to move from one to another database.
You may try

• python ./manage.py dumpdata > data.json

and

• python ./manage.py loaddata data.json

but unfortunately this doesn't work because of integrity errors...or many other issues

For move from one db to another i follow steps:

1. Edit settings.py 
1. add new database in DATABASES settings with 'slave' name like:
   

   DATABASES = {'default': {...}, 'slave': {...}}
   

2. if you use apps like south - comment them for a while
2. Create new db (django create only new file for sqlite database type)
3. Create tables in new db
1. python ./manage.py syncdb --database slave
2. enable south and repeat 3.1
4. Create file to_slave.py in main project directory:

• from django.contrib.contenttypes.models import ContentType
  
  def run():
  
   def do(Table):
    if Table is not None:
     table_objects = Table.objects.all()
     for i in table_objects:
      i.save(using='slave')
   
   ContentType.objects.using('slave').all().delete()
  
   for i in ContentType.objects.all():
    do(i.model_class())
  

5. If you have any kind of signals for you models - disable them before next step
6. run 
1. python ./manage.py shell and type command in shell
1. from to_slave import run
2. run()
7. Make 'slave' default database in you project
8. Done