Re: move to a new server problem
Oh, you were running dumpdata. Yeah, I don't know what caused that issue, but you definitely want dumpdb/loaddb. Christian On Sep 24, 2012, at 5:26, flash wrote: > just to see if it works I tried dumpdb instead of dumpdata and this worked > fine > So as far as I understand the problem is not in the DB, any idea what can > cause this ? > > On Sunday, September 23, 2012 10:16:20 AM UTC+2, flash wrote: > I'm trying to move the data from old server to a new one. > both servers run the same version > On the old server I run "rb-site manage /path/to/site dumpdata > /path/ > to/backup/rbdump.json" > > and get this error: > > File "/usr/local/lib/python2.6/dist-packages/Django-1.3.3-py2.6.egg/ > django/db/models/sql/compiler.py", line 749, in > result = iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)), > pysqlite2.dbapi2.OperationalError: Could not decode to UTF-8 column > 'diff_base64' with text > 'SW5kZXg6IC8vYnJhbmNoZXMvSW5mcmFzdHJ1Y3R1cmUvQm9vc3QxLjQ1X0VmZm9ydC8zcmRQYXJ0 > eUxpYkluc3QvQm9vc3QvYm9vc3QvbXBsL2xpc3QvbGlzdDIwLmhwcAo9PT09PT0 > > Any idea what can be the problem and how can I fix it ? > Thanks. > -- > Want to help the Review Board project? Donate today at > http://www.reviewboard.org/donate/ > Happy user? Let us know at http://www.reviewboard.org/users/ > -~--~~~~--~~--~--~--- > To unsubscribe from this group, send email to > reviewboard+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/reviewboard?hl=en -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
Re: move to a new server problem
just to see if it works I tried dumpdb instead of dumpdata and this worked fine So as far as I understand the problem is not in the DB, any idea what can cause this ? On Sunday, September 23, 2012 10:16:20 AM UTC+2, flash wrote: > > I'm trying to move the data from old server to a new one. > both servers run the same version > On the old server I run "rb-site manage /path/to/site dumpdata > /path/ > to/backup/rbdump.json" > > and get this error: > > File "/usr/local/lib/python2.6/dist-packages/Django-1.3.3-py2.6.egg/ > django/db/models/sql/compiler.py", line 749, in > result = iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)), > pysqlite2.dbapi2.OperationalError: Could not decode to UTF-8 column > 'diff_base64' with text > 'SW5kZXg6IC8vYnJhbmNoZXMvSW5mcmFzdHJ1Y3R1cmUvQm9vc3QxLjQ1X0VmZm9ydC8zcmRQYXJ0 > > eUxpYkluc3QvQm9vc3QvYm9vc3QvbXBsL2xpc3QvbGlzdDIwLmhwcAo9PT09PT0 > > Any idea what can be the problem and how can I fix it ? > Thanks. > -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
Re: move to a new server problem
Actually I wanted to change DB type, but if I wont have any other option I will have to use DB dump If I'm moving using DB dump what else do I need to move to a new server ? Thanks. On Sep 23, 11:10 am, Christian Hammond wrote: > Hi, > > Off-hand, I'm not sure, but you only really want to use these scripts if > you're transferring database types. If they're both, say, MySQL, then use > the database's native SQL dump script (mysqldump, for example). > > Christian > > -- > Christian Hammond - chip...@chipx86.com > Review Board -http://www.reviewboard.org > VMware, Inc. -http://www.vmware.com > > > > > > > > On Sun, Sep 23, 2012 at 1:15 AM, flash wrote: > > I'm trying to move the data from old server to a new one. > > both servers run the same version > > On the old server I run "rb-site manage /path/to/site dumpdata > /path/ > > to/backup/rbdump.json" > > > and get this error: > > > File "/usr/local/lib/python2.6/dist-packages/Django-1.3.3-py2.6.egg/ > > django/db/models/sql/compiler.py", line 749, in > > result = iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)), > > pysqlite2.dbapi2.OperationalError: Could not decode to UTF-8 column > > 'diff_base64' with text > > > 'SW5kZXg6IC8vYnJhbmNoZXMvSW5mcmFzdHJ1Y3R1cmUvQm9vc3QxLjQ1X0VmZm9ydC8zcmRQYXJ0 > > eUxpYkluc3QvQm9vc3QvYm9vc3QvbXBsL2xpc3QvbGlzdDIwLmhwcAo9PT09PT0 > > > Any idea what can be the problem and how can I fix it ? > > Thanks. > > > -- > > Want to help the Review Board project? Donate today at > >http://www.reviewboard.org/donate/ > > Happy user? Let us know athttp://www.reviewboard.org/users/ > > -~--~~~~--~~--~--~--- > > To unsubscribe from this group, send email to > > reviewboard+unsubscr...@googlegroups.com > > For more options, visit this group at > >http://groups.google.com/group/reviewboard?hl=en -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
Re: move to a new server problem
Hi, Off-hand, I'm not sure, but you only really want to use these scripts if you're transferring database types. If they're both, say, MySQL, then use the database's native SQL dump script (mysqldump, for example). Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com On Sun, Sep 23, 2012 at 1:15 AM, flash wrote: > I'm trying to move the data from old server to a new one. > both servers run the same version > On the old server I run "rb-site manage /path/to/site dumpdata > /path/ > to/backup/rbdump.json" > > and get this error: > > File "/usr/local/lib/python2.6/dist-packages/Django-1.3.3-py2.6.egg/ > django/db/models/sql/compiler.py", line 749, in > result = iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)), > pysqlite2.dbapi2.OperationalError: Could not decode to UTF-8 column > 'diff_base64' with text > > 'SW5kZXg6IC8vYnJhbmNoZXMvSW5mcmFzdHJ1Y3R1cmUvQm9vc3QxLjQ1X0VmZm9ydC8zcmRQYXJ0 > eUxpYkluc3QvQm9vc3QvYm9vc3QvbXBsL2xpc3QvbGlzdDIwLmhwcAo9PT09PT0 > > Any idea what can be the problem and how can I fix it ? > Thanks. > > -- > Want to help the Review Board project? Donate today at > http://www.reviewboard.org/donate/ > Happy user? Let us know at http://www.reviewboard.org/users/ > -~--~~~~--~~--~--~--- > To unsubscribe from this group, send email to > reviewboard+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/reviewboard?hl=en > -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en