On 11/20/2011 06:37 PM, Gelonida N wrote: > Hi, > > I for debugging purposes I'd like to clone the data base of one machine > to another one. (both are not necessarily using the same data base engine) > > What would be the suggested procedure? > > What I tried, but what failed is following: > > 1.) On the remote machine > ./manage.py dumpdata > dumpall.json > > 2.) copy dumpall.json to remote machine > > 3.) On the machine to be cloned to: > ./manage.py flush > ./manage.py loaddata dumpall.json > > The error, that I get is: > > IntegrityError: duplicate key value violates unique constraint > "django_content_type_app_label_key" > > > The only ideas, that I have are: > - delete all conflicting tables from the source host before applying my > fixture (I would do the with ./manage.py shell or with a tiny script) > > - dump all apps except the ones causing problems. > > Thanks a lot in advance for any suggestion. > > > What I did now is following (this time the source and destination database were both postgres)
1.) On the remote machine ./manage.py dumpdata > dumpall.json 2.) copy dumpall.json to remote machine 3.) On the machine to be cloned to: ./manage.py sqlflush copy the truncate statement from the output to the clipboard ./manage.py dbshell enter the password and paste the truncate statement and quite the db shell ./manage.py loaddata dumpall.json This is working, but not that nice to automate, as the SQL snippet, that I have to extract from sqlflush depends on the db engine and as I have to be sure, that I have to create a .pgpass entry for postgres in order to avoid the password prompt. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
