Migrating old reivewboard's data to new reviewboard server

[_mike]

Hi,

I’m trying to migrate an existing reviewboard (1.5) on an Ubuntu
server setup to a new reviewboard server (1.6.5) on SLES 11. Their
setups are similar and both servers are using MySQL with the new
server using memcached.
The problem I’m having is trying to import existing data to the new
server. Based on a post from Ian I did the following:

1. On the old server I dumped data using:
rb-site manage /export/oldsite.com dumpdata > rb-dump.json
(a large file was producted over 1Mb)

2. Edited the file in a text editor to remove items who’s model =
"contenttypes.contenttype" or "scmtools.tool" then save the file as
rb-dump-UPDATED.json

3. Copy the dump to the new server then run:
rb-site manage /export/newsite.com loaddata rb-dump-
UPDATED.json

The problem I’m seeing is that as soon as I run rb-site, it exits with
‘No fixtures found.’. Running this command with the un-edited dump
file gives the same result.

Is there something that Im missing here? Is there another way of doing
this?

[Christian Hammond]

"No fixtures found" isn't an error. Sounds like the upgrade finished.

However, you're going about the upgrade in a way that will break things: Putting old schema data into a new schema.

In your case, since both are MySQL, you should:

1) Do a mysqldump on the old server.
2) Drop the database on the new one and recreate it by hand (must be empty!)
3) Use mysql to import the dump.
4) Run rb-site upgrade.

Christian

> --
> 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...@googlegroups.com
> For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en

[_mike]

Thanks Christian!

That did the trick.

The only other thing I had to do was increase mysqls' max_allowed_packet size.

Got a few *There are unapplied evolutions for sessions, accounts, changedescs, reviews, scmtools,...* but the upgrade did complete. 

[Christian Hammond]

Those are just part of the output from one command it runs. It then runs the command to resolve that. We'll probably want to start hiding those..

Glad it works!

Christian

--
Christian Hammond - chi...@chipx86.com
Review Board - http://www.reviewboard.org
VMware, Inc. - http://www.vmware.com

[Dennis Miller]

Is this procedure valid for going from 1.5.5 --> 1.7.25?