admin@remotehost1:~$ export REVIEWBOARD_DB_NAME=review admin@remotehost1:~$ mysqldump -u backup -p --max_allowed_packet=512M $REVIEWBOARD_DB_NAME > /tmp/reviewboard-`date`.sql admin@remotehost1:~$ scp /tmp/reviewboard-`date`.sql admin@remotehost2:/tmp/ admin@remotehost1:~$ scp -r /var/www/reviewboard-1.5.2 admin@remotehost2:/var/www/reviewboard-1.7.14
admin@remotehost2:~$ sudo apt-get install mysql-server libmysqlclient-dev memcached ntpd apache2 libapach2-mod-wsgi libapache2-mod-python admin@remotehost2:~$ sudo easy_install Reviewboard==1.7.14 Django==1.4.10 python-memcached MySQL-Python admin@remotehost2:~$ sudo easy_install -m Reviewboard==1.7.14 admin@remotehost2:~$ sudo cp /var/www/reviewboard-1.7.14/conf/settings_local.py /home/admin admin@remotehost2:~$ vim /home/admin/settings_local.py (make the mentioned changes from my thread) admin@remotehost2:~$ sudo cp /home/admin/settings_local.py /usr/local/lib/python2.7/dist-packages/Reviewboard-1.7.14-py2.7.egg/reviewboard/ admin@remotehost2:~$ mysql -u root -p mysql> create database review; mysql> create user 'review'@'localhost' identified by 'password'; mysql> grant all on review.* to 'review'@'localhost'; admin@remotehost2:~$ mysql --max_allowed_packet=128M -u review -p review < /tmp/reviewboard-`date`.sql admin@remotehost2:~$ mysql -u root -p review mysql> show table status mysql> alter table `table_name` engine='InnoDB'; (there are definitely faster ways, but I can't spoon feed you everything...) admin@remotehost2:~$ sudo rb-site --version (confirm you are at 1.7.14) admin@remotehost2:~$ sudo rb-site upgrade /var/www/reviewboard-1.7.14 For Apache, you will need to add: <Location "/review/static"> SetHandler None </Location> Alias /review/static "/var/www/reviewboard-1.7.14/htdocs/static<http://review.company.com/htdocs/static> " For lighttpd: alias.url = ( ... "/review/static" => "/var/www/review.company.com/htdocs/static", ... ) url.rewrite-once = ( ... "^(/review/static/.*)$" => "$1", ... ) Once you have made these changes, type the following to resolve this: $ rb-site manage /var/www/r <http://review.company.com/>eviewboard-1.7.14 resolve-check static-media Make the changes... admin@remotehost2:~$ ln -s /var/www/reviewboard-1.7.14 /var/www/review admin@remotehost2:~$ rb-site manage /var/www/reviewboard-1.7.14 resolve-check static-media And for good measure... admin@remotehost2:~$ rb-site manage /var/www/reviewboard-1.7.14 syncdb Hope that helps, KP On Wednesday, March 19, 2014 3:11:13 AM UTC-7, Bhaskar Roy wrote: > > Hi Kevin, > > I did what you said but I am on same page. > > Can you please provide the procedure to do migration. > > > regards > bahskar > > > On Wed, Mar 19, 2014 at 12:38 AM, Kevin Phillips < > kevin.grenvi...@gmail.com <javascript:>> wrote: > >> Your database dump appears incomplete. Try dumping with >> --max_allowed_packet=512M (large packet to avoid truncation). Check your >> 1.5.X db and verify the table exists in production and in the backup. Also >> verify all your tables are InnoDB instead of MYISAM, you can make manual >> modification to the table engine without much recourse. >> >> Take a look at my thread, I just migrated 1.5.2 to 1.7.14 on the same >> platform as you. >> >> KP >> >> >> On Tuesday, March 18, 2014 2:31:44 AM UTC-7, Bhaskar Roy wrote: >> >>> Hi Christian, >>> >>> I am trying migration on new server and not in current production box. >>> >>> 1. On new server I installed ubuntu 12.04/mysql 5.5/RB 1.7.14 >>> 1. I took backup of SQL and copied to new server and done rb-site >>> upgrade. >>> >>> Copied the databse to new server and tired . I get error messages as >>> listed above. >>> >>> regards >>> Bhaskar >>> >>> >>> On Thu, Mar 13, 2014 at 12:53 AM, Christian Hammond >>> <chi...@chipx86.com>wrote: >>> >>>> Hi, >>>> >>>> First, did you back up your database? >>>> >>>> Second, can you verify the version of Review Board you've upgraded to, >>>> and also verify the version of django-evolution installed? (These should >>>> be >>>> in your Python's site-packages directory). >>>> >>>> You shouldn't do *any* hand-modifying of the database of any sort, or >>>> you'll cause further issues in the upgrade process. Our stuff expects to >>>> own the full schema of the database. >>>> >>>> Christian >>>> >>>> -- >>>> Christian Hammond - chi...@chipx86.com >>>> >>>> Review Board - http://www.reviewboard.org >>>> Beanbag, Inc. - http://www.beanbaginc.com >>>> >>>> >>>> On Wed, Mar 12, 2014 at 3:23 AM, Bhaskar Roy <bhaska...@gmail.com>wrote: >>>> >>>>> Hi Christian, >>>>> >>>>> I am getting following error while doing site upgrade from 1.5 to >>>>> Latest 1.7. >>>>> Even created auth_message tablein MySqL DB. >>>>> >>>>> >>>>> /usr/bin/python /usr/local/bin/rb-site upgrade "/var/www/reviewboard" >>>>> Rebuilding directory structure >>>>> Updating database. This may take a while. >>>>> >>>>> The log output below, including warnings and errors, >>>>> can be ignored unless upgrade fails. >>>>> >>>>> ------------------ <begin log output> ------------------ >>>>> Creating tables ... >>>>> There are unapplied evolutions for auth. >>>>> There are unapplied evolutions for sessions. >>>>> There are unapplied evolutions for accounts. >>>>> There are unapplied evolutions for changedescs. >>>>> There are unapplied evolutions for diffviewer. >>>>> There are unapplied evolutions for reviews. >>>>> There are unapplied evolutions for scmtools. >>>>> Project signature has changed - an evolution is required >>>>> Installing custom SQL ... >>>>> Installing indexes ... >>>>> Installed 0 object(s) from 0 fixture(s) >>>>> Evolution could not be simulated, possibly due to raw SQL mutations >>>>> Error: Error applying evolution: (1051, "Unknown table 'auth_message'") >>>>> >>>>> Regards >>>>> bhaskar >>>>> >>>>> -- >>>>> 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...@googlegroups.com. >>>>> >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- >>>> 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...@googlegroups.com. >>>> >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> 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...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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.