Electronics & Programming

develissimo

Open Source electronics development and programming

  • You are not logged in.
  • Root
  • » Django
  • » Can't use dumpdata and loaddata to migrate non-ASCII data between databases [RSS Feed]

#1 Jan. 3, 2011 23:35:44

Eric C.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

Can't use dumpdata and loaddata to migrate non-ASCII data between databases


Hi,

We are trying to migrate between databases and we are running into a problem
while trying to use dumpdata. We've tried:

./manage.py dumpdata --natural --indent 2 > dump.json

and:

./manage.py dumpdata --natural --format xml --indent 2 > dump.xml

Both return the following error:

Error: Unable to serialize database: 'ascii' codec can't encode
character u'\xe9' in position 18: ordinal not in range(128)

Is there a way to dump and load non-ASCII data?


--
Eric Chamberlain, Founder
RF.com -http://RF.com/--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#2 Jan. 3, 2011 23:49:45

Eric C.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

Can't use dumpdata and loaddata to migrate non-ASCII data between databases


Or is there a better way to migrate a database from postgres to MySQL?


On Jan 3, 2011, at 6:35 PM, Eric Chamberlain wrote:

> Hi,
>
> We are trying to migrate between databases and we are running into a problem
> while trying to use dumpdata. We've tried:
>
> ./manage.py dumpdata --natural --indent 2 > dump.json
>
> and:
>
> ./manage.py dumpdata --natural --format xml --indent 2 > dump.xml
>
> Both return the following error:
>
> Error: Unable to serialize database: 'ascii' codec can't encode
> character u'\xe9' in position 18: ordinal not in range(128)
>
> Is there a way to dump and load non-ASCII data?
>
>
> --
> Eric Chamberlain, Founder
> RF.com -http://RF.com/>
>
>
>
>
>
>

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#3 Jan. 7, 2011 13:52:35

d.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

Can't use dumpdata and loaddata to migrate non-ASCII data between databases


Maybe Google for this? e.g.http://www.codesmell.org/blog/2009/03/migrate-data-from-postgres-to-mysql/On Jan 4, 1:49 am, Eric Chamberlain <e...@rf.com> wrote:
> Or is there a better way to migrate a database from postgres to MySQL?
>
> On Jan 3, 2011, at 6:35 PM, Eric Chamberlain wrote:
>
>
>
>
>
>
>
> > Hi,
>
> > We are trying to migrate between databases and we are running into a
> > problem while trying to use dumpdata.  We've tried:
>
> >    ./manage.py dumpdata --natural --indent 2 > dump.json
>
> > and:
>
> >    ./manage.py dumpdata --natural --format xml --indent 2 > dump.xml
>
> > Both return the following error:
>
> >    Error: Unable to serialize database: 'ascii' codec can't encode
> > character u'\xe9' in position 18: ordinal not in range(128)
>
> > Is there a way to dump and load non-ASCII data?
>
> > --
> > Eric Chamberlain, Founder
> > RF.com -http://RF.com/--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

  • Root
  • » Django
  • » Can't use dumpdata and loaddata to migrate non-ASCII data between databases [RSS Feed]

Board footer

Moderator control

Enjoy the 23rd of October
PoweredBy

The Forums are managed by develissimo stuff members, if you find any issues or misplaced content please help us to fix it. Thank you! Tell us via Contact Options
Leave a Message
Welcome to Develissimo Live Support