Hi, Where did those steps come from? The dumpdata command is not recommended as it's not guaranteed to work, and has scalability problems.
What I'd strongly encourage is to do the upgrade to 2.5.7 on MySQL, and then look into converting to Postgres. That way, you're not attempting a DB transition while doing a version upgrade. That should also avoid the error you're hitting with filediffdata (which was renamed in 2.5). We are working on a new database export/import tool that can upgrade/downgrade databases, transition between different database types, and even selectively export/import specific Local Sites or review requests (allowing servers to be split or merged). This will ship with Power Pack in an upcoming release. Christian I would recommend if at all On Sun, Dec 18, 2016 at 18:41 Pramudita Santoso < [email protected]> wrote: > Hi, > > I am trying to migrate all my data in old server v2.0.17 to new server > with v2.5.7 > > I tried to follow this steps: > > 1. On the old server, dump your site data. > sudo rb-site manage /path/to/site dumpdata > /path/to/backup/rbdump.json > 2. Open the dump file in a text editor and find all the entries > whose "model" is "contenttypes.contenttype" or "scmtools.tool", and delete > those entries. > 3. On the new server, create a new site following the directions on the > ReviewBoard site. Note that you don't have to use the same database type > as your old server (my old server used MySQL, my new server uses > PostgreSQL). > 4. On the new server, load the old site data. > sudo rb-site manage /path/to/site loaddata /path/to/backup/rbdump.json > > > using sed command to substitute rbdump.json (step 2) > > sed 's/{"pk": [0-9][0-9]*, "model": "contenttypes\.contenttype", "fields": > {"model": "[a-z][a-z]*", "name": "[a-z ][a-z ]*", "app_label": > "[a-z_][a-z_]*"}},//g' ../rbdump.json > ../rbdump2.json > > > However the output is below: > > Traceback (most recent call last): > File "/usr/bin/rb-site", line 9, in <module> > load_entry_point('ReviewBoard==2.5.7', 'console_scripts', 'rb-site')() > File "/usr/lib/python2.7/site-packages/reviewboard/cmdline/rbsite.py", > line 1937, in main > command.run() > File "/usr/lib/python2.7/site-packages/reviewboard/cmdline/rbsite.py", > line 1863, in run > site.run_manage_command(args[0], args[1:]) > File "/usr/lib/python2.7/site-packages/reviewboard/cmdline/rbsite.py", > line 691, in run_manage_command > execute_from_command_line([__file__, cmd] + params) > File > "/usr/lib/python2.7/site-packages/django/core/management/__init__.py", line > 399, in execute_from_command_line > utility.execute() > File > "/usr/lib/python2.7/site-packages/django/core/management/__init__.py", line > 392, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File "/usr/lib/python2.7/site-packages/django/core/management/base.py", > line 242, in run_from_argv > self.execute(*args, **options.__dict__) > File "/usr/lib/python2.7/site-packages/django/core/management/base.py", > line 285, in execute > output = self.handle(*args, **options) > File > "/usr/lib/python2.7/site-packages/django/core/management/commands/loaddata.py", > line 55, in handle > self.loaddata(fixture_labels) > File > "/usr/lib/python2.7/site-packages/django/core/management/commands/loaddata.py", > line 84, in loaddata > self.load_label(fixture_label) > File > "/usr/lib/python2.7/site-packages/django/core/management/commands/loaddata.py", > line 134, in load_label > for obj in objects: > File "/usr/lib/python2.7/site-packages/django/core/serializers/json.py", > line 76, in Deserializer > six.reraise(DeserializationError, DeserializationError(e), > sys.exc_info()[2]) > File "/usr/lib/python2.7/site-packages/django/core/serializers/json.py", > line 70, in Deserializer > for obj in PythonDeserializer(objects, **options): > File > "/usr/lib/python2.7/site-packages/django/core/serializers/python.py", line > 90, in Deserializer > Model = _get_model(d["model"]) > File > "/usr/lib/python2.7/site-packages/django/core/serializers/python.py", line > 153, in _get_model > raise base.DeserializationError("Invalid model identifier: '%s'" % > model_identifier) > django.core.serializers.base.DeserializationError: Problem installing > fixture '/var/www/reviewboard/rbdump.json': Invalid model identifier: > 'diffviewer.filediffdata' > > > I also have been trying other method simply dump my postgresdb to new > machine, but it does not work (I am using docker container) > > 1) Do a pg_dump on the old database server. > 2) Use pg_restore to import the dump in the new database container. > 3) Run rb-site install and connect rb container to database container. > > 4) There is no error but login is incorrect and menu bar is missing > > > I am pretty clueless, been working on this for days and I have no idea > which method should I go with - noting that those guides are pretty old. > Could you please advise me the steps to upgrade v2.0.17 to v2.5.7. Thank > you so much! > > > > > > > > > -- > > > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > > > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > > > Happy user? Let us know! https://www.reviewboard.org/users/ > > > --- > > > You received this message because you are subscribed to the Google Groups > "reviewboard" group. > > > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > > For more options, visit https://groups.google.com/d/optout. > > > -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
