I tried this out and didn't have much luck. Any thoughts on whether
this is a django issue or reviewboard issue?

$ rb-site manage /home/reviewboard_head dumpdata -- --verbosity=2 --
traceback --format=xml > dump                                    .xml
Traceback (most recent call last):
  File "/usr/bin/rb-site", line 9, in <module>
    load_entry_point('ReviewBoard==1.5beta2.dev-20100422',
'console_scripts', 'rb-site')()
  File "/usr/lib/python2.5/site-packages/
ReviewBoard-1.5beta2.dev_20100422-py2.5.egg/reviewboard/cmdline/
rbsite.py", line 1583, in main
    command.run()
  File "/usr/lib/python2.5/site-packages/
ReviewBoard-1.5beta2.dev_20100422-py2.5.egg/reviewboard/cmdline/
rbsite.py", line 1517, in run
    site.run_manage_command(args[0], args[1:])
  File "/usr/lib/python2.5/site-packages/
ReviewBoard-1.5beta2.dev_20100422-py2.5.egg/reviewboard/cmdline/
rbsite.py", line 377, in run_manage_command
    execute_manager(reviewboard.settings, [__file__, cmd] + params)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
core/management/__init__.py", line 362, in execute_manager
    utility.execute()
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
core/management/__init__.py", line 303, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
core/management/base.py", line 195, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
core/management/base.py", line 222, in execute
    output = self.handle(*args, **options)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
core/management/commands/dumpdata.py", line 80, in handle
    return serializers.serialize(format, objects, indent=indent)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
core/serializers/__init__.py", line 87, in serialize
    s.serialize(queryset, **options)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
core/serializers/base.py", line 47, in serialize
    self.handle_fk_field(obj, field)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
core/serializers/xml_serializer.py", line 82, in handle_fk_field
    related = getattr(obj, field.name)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/fields/related.py", line 257, in __get__
    rel_obj = QuerySet(self.field.rel.to).get(**params)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/query.py", line 299, in get
    clone = self.filter(*args, **kwargs)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/query.py", line 498, in filter
    return self._filter_or_exclude(False, *args, **kwargs)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/query.py", line 516, in _filter_or_exclude
    clone.query.add_q(Q(*args, **kwargs))
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/sql/query.py", line 1675, in add_q
    can_reuse=used_aliases)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/sql/query.py", line 1614, in add_filter
    connector)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/sql/where.py", line 56, in add
    obj, params = obj.process(lookup_type, value)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/sql/where.py", line 269, in process
    params = self.field.get_db_prep_lookup(lookup_type, value)
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/fields/__init__.py", line 210, in get_db_prep_lookup
    return [self.get_db_prep_value(value)]
  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
db/models/fields/__init__.py", line 361, in get_db_prep_value
    return int(value)
ValueError: invalid literal for int() with base 10: 'changedesc_id'

Dan


On May 5, 4:44 am, Christian Hammond <chip...@chipx86.com> wrote:
> Hi,
>
> The SQL dump formats are different between sqlite3 and MySQL. There's no
> great way to transition between these. This is something that has come up a
> lot lately, so we may have to look into reviving our old DB migration
> scripts which dump to a common format and then load back in.
>
> Depending on the size of your database, you may be able to use Django's
> dumping/loading logic. I seem to recall that it didn't handle large
> databases well, but you can give it a try.
>
> On the old server, do:
>
>     rb-site manage /path/to/site dumpdata --format=xml >
> reviewboard-dump.xml
>
> On the new server:
>
>     rb-site manage /path/to/site loaddata reviewboard-dump.xml
>
> You will need to do this with the same version of Review Board on the new
> server as on the old. So, first install the old version, attempt that dump,
> and make sure the site comes back up. Then attempt a Review Board and site
> upgrade.
>
> I don't know for sure that this will work, but it's worth a try.
>
> Christian
>
> --
> Christian Hammond - chip...@chipx86.com
> Review Board -http://www.reviewboard.org
> VMware, Inc. -http://www.vmware.com
>
>
>
>
>
> On Tue, May 4, 2010 at 11:50 PM, WANG Yanchao <yanchaow...@gmail.com> wrote:
> > Hi, there:
> > I have a problem: How to migrate a reviewboard site to another reviewboard
> > site.
> > *Background:* We have been using reviewboard+sqlite on one server for a
> > long time(2 years). And recently we have been have performance issues. So we
> > bought a new server and set up a new instance of reviewboard, we are
> > planning to use mysql instead of sqlite.
> > *Versions and OS:* The old one review board
> > is ReviewBoard-1.0alpha2.dev_20090120-py2.5.egg on debian, and the new one
> > is ReviewBoard-1.0.7-py2.5.egg/ on redhat
> > *My question:* is how to move all the users/review groups and review
> > requests data from the old review board to the new one. Can I use sqlite3 to
> > dump the database and then import to the new reviewboard database( mysql)
>
> > Thanks!
> > -Yanchao
>
> >  --
> > 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<reviewboard%2bunsubscr...@googlegr 
> > oups.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 
> athttp://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 
> athttp://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

Reply via email to