Hi.

We have an old Reviewboard install 1.6.22  , I'm attempting to migrate from
sqlite to mysql using the rb-site tools. But I get allot of errors and
sometimes a screen for of characters scrolls by.

Importing new style dump format (v1)
Error: (1062, "Duplicate entry 'changedescs-changedescription' for key
'app_label'")
Line 528: '{"pk": 12, "model": "contenttypes.contenttype", "fields":
{"model": "changedescription", "name": "change description", "app_label":
"changedescs"}}
'Error: (1062, "Duplicate entry 'reviews-comment' for key 'app_label'")
Line 529: '{"pk": 21, "model": "contenttypes.contenttype", "fields":
{"model": "comment", "name": "comment", "app_label": "reviews"}}
'Error: (1062, "Duplicate entry 'reviews-defaultreviewer' for key
'app_label'")
Line 531: '{"pk": 17, "model": "contenttypes.contenttype", "fields":
{"model": "defaultreviewer", "name": "default reviewer", "app_label":
"reviews"}}
'Error: (1062, "Duplicate entry 'diffviewer-diffset' for key 'app_label'")
Line 532: '{"pk": 14, "model": "contenttypes.contenttype", "fields":
{"model": "diffset", "name": "diff set", "app_label": "diffviewer"}}
'Error: (1062, "Duplicate entry 'diffviewer-diffsethistory' for key
'app_label'")
Line 533: '{"pk": 15, "model": "contenttypes.contenttype", "fields":
{"model": "diffsethistory", "name": "diff set history", "app_label":
"diffviewer"}}
'Error: (1062, "Duplicate entry 'django_evolution-evolution' for key
'app_label'")
Line 534: '{"pk": 27, "model": "contenttypes.contenttype", "fields":
{"model": "evolution", "name": "evolution", "app_label":
"django_evolution"}}
'Error: (1062, "Duplicate entry 'attachments-fileattachment' for key
'app_label'")
Line 535: '{"pk": 29, "model": "contenttypes.contenttype", "fields":
{"model": "fileattachment", "name": "file attachment", "app_label":
"attachments"}}
'Error: (1062, "Duplicate entry 'reviews-fileattachmentcomment' for key
'app_label'")
Line 536: '{"pk": 31, "model": "contenttypes.contenttype", "fields":
{"model": "fileattachmentcomment", "name": "file attachment comment",
"app_label": "reviews"}}
'Error: (1062, "Duplicate entry 'diffviewer-filediff' for key 'app_label'")
Line 537: '{"pk": 13, "model": "contenttypes.contenttype", "fields":
{"model": "filediff", "name": "file diff", "app_label": "diffviewer"}}
'Error: (1062, "Duplicate entry 'hostingsvcs-hostingserviceaccount' for key
'app_label'")
Line 539: '{"pk": 30, "model": "contenttypes.contenttype", "fields":
{"model": "hostingserviceaccount", "name": "hosting service account",
"app_label": "hostingsvcs"}}
'Error: (1062, "Duplicate entry 'site-localsite' for key 'app_label'")
Line 540: '{"pk": 32, "model": "contenttypes.contenttype", "fields":
{"model": "localsite", "name": "local site", "app_label": "site"}}
'Error: (1062, "Duplicate entry 'accounts-localsiteprofile' for key
'app_label'")
Line 541: '{"pk": 28, "model": "contenttypes.contenttype", "fields":
{"model": "localsiteprofile", "name": "local site profile", "app_label":
"accounts"}}
'Error: (1062, "Duplicate entry 'scmtools-repository' for key 'app_label'")
Line 546: '{"pk": 25, "model": "contenttypes.contenttype", "fields":
{"model": "repository", "name": "repository", "app_label": "scmtools"}}
'Error: (1062, "Duplicate entry 'reviews-review' for key 'app_label'")
Line 547: '{"pk": 23, "model": "contenttypes.contenttype", "fields":
{"model": "review", "name": "review", "app_label": "reviews"}}
'Error: (1062, "Duplicate entry 'reviews-group' for key 'app_label'")
Line 548: '{"pk": 16, "model": "contenttypes.contenttype", "fields":
{"model": "group", "name": "review group", "app_label": "reviews"}}
'Error: (1062, "Duplicate entry 'reviews-reviewrequest' for key
'app_label'")
Line 549: '{"pk": 19, "model": "contenttypes.contenttype", "fields":
{"model": "reviewrequest", "name": "review request", "app_label":
"reviews"}}
'Error: (1062, "Duplicate entry 'reviews-reviewrequestdraft' for key
'app_label'")
Line 550: '{"pk": 20, "model": "contenttypes.contenttype", "fields":
{"model": "reviewrequestdraft", "name": "review request draft",
"app_label": "reviews"}}
'Error: (1062, "Duplicate entry 'reviews-screenshot' for key 'app_label'")
Line 552: '{"pk": 18, "model": "contenttypes.contenttype", "fields":
{"model": "screenshot", "name": "screenshot", "app_label": "reviews"}}
'Error: (1062, "Duplicate entry 'reviews-screenshotcomment' for key
'app_label'")
Line 553: '{"pk": 22, "model": "contenttypes.contenttype", "fields":
{"model": "screenshotcomment", "name": "screenshot comment", "app_label":
"reviews"}}
'Error: (1062, "Duplicate entry 'scmtools-tool' for key 'app_label'")
Line 557: '{"pk": 24, "model": "contenttypes.contenttype", "fields":
{"model": "tool", "name": "tool", "app_label": "scmtools"}}
'Error: (1062, "Duplicate entry 'django_evolution-version' for key
'app_label'")
Line 559: '{"pk": 26, "model": "contenttypes.contenttype", "fields":
{"model": "version", "name": "version", "app_label": "django_evolution"}}

and

'/usr/lib/python2.6/site-packages/Django-1.3.7-py2.6.egg/django/db/backends/mysql/base.py:86:
Warning: Incorrect string value: '\xE2\x9E\x9C  ~...' for column
'testing_done' at row 1
  return self.cursor.execute(query, args)
/usr/lib/python2.6/site-packages/Django-1.3.7-py2.6.egg/django/db/backends/mysql/base.py:86:
Warning: Incorrect string value: '\xEE\x80\x92\xEE\x80\x92...' for column
'testing_done' at row 1
  return self.cursor.execute(query, args)
/usr/lib/python2.6/site-packages/Django-1.3.7-py2.6.egg/django/db/backends/mysql/base.py:86:
Warning: Incorrect string value: '\xCE\xBCs, a...' for column 'description'
at row 1
  return self.cursor.execute(query, args)



my database configuration

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'reviewboard',
        'USER': 'reviewboard',
        'PASSWORD': 'password',
        'HOST': 'dbserver,
        'PORT': ''
    },
}

these are the steps I followed :

rb-site manage /var/www/reviewboard dumpdb > /home/greg/database.jason
edit db config
rb-site manage /var/www/reviewboard syncdb --
rb-site manage /var/www/reviewboard loaddb /home/greg/database.jason


I also can't find any docs on dumpdb, syncdb and loaddb.

This is the first step to moving onto a supported version.

Can you advise what the best solution is ?

Thank you

-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://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 reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to