I'm trying to move django data from an sqlite database to a mysql database.
I know I need to use natural keys, but it's still failing. Any ideas?
Here's my procedure. The default database is sqlite, the mysql database is
called "mysql" in settings.py.
$*./manage.py dumpdata -a -n > data.json*
$*./manage.py flush --database=mysql*
You have requested a flush of the database.
This will IRREVERSIBLY DESTROY all data currently in the 'django' database,
and return each table to the state it was in after syncdb.
Are you sure you want to do this?
Type 'yes' to continue, or 'no' to cancel: yes
You just installed Django's auth system, which means you don't have any
superusers defined.
Would you like to create one now? (yes/no): no
Installed 0 object(s) from 0 fixture(s)
*Note - if I examine the mysql database at this point, the tables all exist
and contain 0 rows (as I expected)*
$*./manage.py loaddata --database=mysql ./data.json*
Problem installing fixture './data.json': Traceback (most recent call last):
File
"/usr/local/lib/python2.6/site-packages/django/core/management/commands/loaddata.py",
line 196, in handle
obj.save(using=using)
File
"/usr/local/lib/python2.6/site-packages/django/core/serializers/base.py",
line 165, in save
models.Model.save_base(self.object, using=using, raw=True)
File "/usr/local/lib/python2.6/site-packages/django/db/models/base.py",
line 565, in save_base
created=(not record_exists), raw=raw, using=using)
File
"/usr/local/lib/python2.6/site-packages/django/dispatch/dispatcher.py",
line 172, in send
response = receiver(signal=self, sender=sender, **named)
File "/genpool0/db/foo/intranet/../intranet/userprofile/models.py", line
22, in create_user_profile
UserProfile.objects.create(user=instance)
File
"/usr/local/lib/python2.6/site-packages/django/db/models/manager.py", line
137, in create
return self.get_query_set().create(**kwargs)
File "/usr/local/lib/python2.6/site-packages/django/db/models/query.py",
line 377, in create
obj.save(force_insert=True, using=self.db)
File "/usr/local/lib/python2.6/site-packages/django/db/models/base.py",
line 463, in save
self.save_base(using=using, force_insert=force_insert,
force_update=force_update)
File "/usr/local/lib/python2.6/site-packages/django/db/models/base.py",
line 551, in save_base
result = manager._insert([self], fields=fields, return_id=update_pk,
using=using, raw=raw)
File
"/usr/local/lib/python2.6/site-packages/django/db/models/manager.py", line
203, in _insert
return insert_query(self.model, objs, fields, **kwargs)
File "/usr/local/lib/python2.6/site-packages/django/db/models/query.py",
line 1576, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File
"/usr/local/lib/python2.6/site-packages/django/db/models/sql/compiler.py",
line 910, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python2.6/site-packages/django/db/backends/util.py",
line 40, in execute
return self.cursor.execute(sql, params)
File
"/usr/local/lib/python2.6/site-packages/django/db/backends/sqlite3/base.py",
line 337, in execute
return Database.Cursor.execute(self, query, params)
IntegrityError: Could not load auth.User(pk=1): column user_id is not unique
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/django-users/-/t0RMEEtwXacJ.
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.
