I've inherited the admin/config-management of an under-managed review board
system and find that a simple conversion is not straight-forward if there
is a fair amount of reviews in the system already -- ours is about 4.5GB.
We're running rb-1.5.1, but planning to upgrade after the db conversion.
I was able to remove the entries 'whose "model" is
"contenttypes.contenttype"' using a simple sed command that others may find
useful (standard disclaimer regarding no warranty or liability assumed):
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
I'm getting a curious error with the rb-site manage <path> loaddata command
and I've isolated it to a particular sqlite record that's about 300K in
length (uuencoded diff, of course). The error stack is
Problem installing fixture '/backup/rbdump-0906-master.json': Traceback
(most recent call last):
File
"/usr/lib/python2.5/site-packages/django/core/management/commands/loaddata.py",
line 165, in handle
for obj in objects:
File "/usr/lib/python2.5/site-packages/django/core/serializers/json.py",
line 38, in Deserializer
for obj in PythonDeserializer(simplejson.load(stream), **options):
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/__init__.py",
line 298, in load
parse_constant=parse_constant, **kw)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/__init__.py",
line 338, in loads
return _default_decoder.decode(s)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/decoder.py", line
326, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/decoder.py", line
342, in raw_decode
obj, end = self.scan_once(s, idx)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/scanner.py", line
38, in _scan_once
return parse_array((string, idx + 1), _scan_once)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/decoder.py", line
226, in JSONArray
value, end = scan_once(s, end)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/scanner.py", line
36, in _scan_once
return parse_object((string, idx + 1), encoding, strict, _scan_once,
object_hook)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/decoder.py", line
176, in JSONObject
value, end = scan_once(s, end)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/scanner.py", line
36, in _scan_once
return parse_object((string, idx + 1), encoding, strict, _scan_once,
object_hook)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/decoder.py", line
176, in JSONObject
value, end = scan_once(s, end)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/scanner.py", line
34, in _scan_once
return parse_string(string, idx + 1, encoding, strict)
File
"/usr/lib/python2.5/site-packages/django/utils/simplejson/decoder.py", line
105, in py_scanstring
errmsg("Invalid \\escape: %r" % (esc,), s, end))
ValueError: Invalid \escape: 'U': line 1 column -2147483586 (char
-2147483586)
Has anybody else tried to migrate/convert a large sqlite configuration?
On Thursday, November 17, 2011 12:14:36 AM UTC-8, Ian wrote:
>
> Oh, and if the path to the site is different on the new server, you'll
> need to do a find&replace in the dump file.
>
> On Wed, Nov 16, 2011 at 11:18 PM, Mail Team <emai...@gmail.com<javascript:>
> > wrote:
>
>> I *just* finished doing this on my server, not super intuitive but once
>> you get the process it works pretty well. You need to still have your old
>> server running for this to work.
>>
>> 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
>>
>> 5. (Optional) For good measure, reboot your new server.
>>
>> On Wed, Nov 16, 2011 at 7:28 PM, RAY <ervin.z...@gmail.com
>> <javascript:>>wrote:
>>
>>> I had a reviewboard using in a server in past, but now the server has
>>> been replaced by new computer. I have install a new reviewboard
>>> environment on this new computer, and then I need move all original
>>> data from old environment to new one. How to move it?
>>> Could I backup database from old reviewboard and recover it on new?
>>>
>>
--
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
