Hi Christian, No, we never discussed them before. I did some searching when I tried. I copied the existing config and data over. I dumped the old database (mysql dump) and re-created it. I did the conversion from MyISAM to InnoDB. But I then kept hitting errors during site upgrade. Sadly I didn't keep full notes but I gave up after a day or so of attempted tweaking.
The id in reviews_reviewrequest is simple enough, so I'll go with that approach. Thanks. On Wednesday, 19 September 2018 11:12:56 UTC+10, Christian Hammond wrote: > > Hi Peter, > > What issues did you hit before? (Have we already talked about them? > Apologies if we have..). We can generally help with relocation and upgrade > issues under support contracts, in case you want to discuss that option. > > As for ID numbers, they're based on the next auto-incremented ID returned > from the database. So what you can do is create a dummy entry in > reviews_reviewrequest with ID, say, 9999, and then Review Board's next ID > will be 10000. You can then delete the dummy entry so it's not sticking > around. > > I'd recommend taking the time to go through every table from the old > database and make sure there's a dummy entry at a higher ID in the new > database, to basically reserve space in each table. That way, if you want > to work with us later on getting the old data moved over to the newer > version, we should be able to just merge the databases and keep all history > in the new place. > > Christian > > On Tue, Sep 18, 2018 at 4:17 PM Peter Howard <[email protected] > <javascript:>> wrote: > >> Dear all, >> >> I've just done a new ReviewBoard install (CentOS7, RB 2.5.17), given >> "issues" trying to transfer our existing (ancient) install. This means the >> old site is going to remain live indefinitely for historical purposes. >> What I would like to do with the new site is get review numbers in the new >> site to start from well above the last number in the old site, to make it >> clear at a glance which site holds the reivew. Is there an >> easy/straightforward way to do that? >> >> Thanks, >> >> PJH >> >> -- >> 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 >> "Review Board Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > Christian Hammond > President/CEO of Beanbag <https://www.beanbaginc.com/> > Makers of Review Board <https://www.reviewboard.org/> > -- 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 "Review Board Community" 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.
