Menu
▾
▴
Re: [Bodington-developers] 2.8 db updates?
|
From: Colin T. <col...@ou...> - 2006-08-31 09:28:09
|
Alistair Young wrote: > is it necessary to explicitly run /setup instead of /site? Yes > will / > setup not drop and recreate existing tables and lose the existing > content? No (unless you choose that option). When you run /setup it should tell you what version of the code the existing database is compatible with. It also lists existing tables and missing tables. If you choose to continue, it will run the upgrade SQL and then give you a page with a link to enter the site (that's when I had to reload the webapp, as the clicking on the link to go to the site gave me an error page.) If you run /setup again, after upgrading and reloading, it should report the database as supporting the current version, and there should be no list of missing tables. Why don't you test it with a database dump, and see what harpoons? Colin > On 31 Aug 2006, at 10:04, Colin Tatham wrote: > > >>Alistair Young wrote: >> >>>brilliant! thanks Colin. >> >>Just checked, and the SQL for Newsfeeds is included, so you don't >>need to run that separately. >>Also noticed that I needed to reload the webapp after running Setup >>Servlet (but SetupServlet >>managed to identify the missing tables and create them OK...) >> >>Colin >> >> >>>Bring your earplugs to the tetra bash, the >>>fc will be piping us in! >>> >>>Alistair >>> >>>On 31 Aug 2006, at 09:32, Colin Tatham wrote: >>> >>> >>> >>>>Alistair Young wrote: >>>> >>>> >>>>>Thanks Colin. I'm showing my ignorance here but how does one run >>>>>the >>>>>upgrade code? I presume running setup on a live database is a bad >>>>>thing? Is it something else that should be run? >>>> >>>>When you run the 2.8 code against an existing database it should >>>>detect the version (by looking at >>>>existing tables) and then automatically run any SQL necessary. >>>>Obviously test it on a dump of your >>>>live data first! >>>> >>>>You'll need to run the NewsFeed SQL separately, as it's not >>>>included in the upgrade code. >>>> >>>>Colin >>>> >>>> >>>> >>>>>On 31 Aug 2006, at 08:59, Colin Tatham wrote: >>>>> >>>>> >>>>> >>>>> >>>>>>Alistair Young wrote: >>>>>> >>>>>> >>>>>> >>>>>>>Dearest bodders, it's been a while but now we're upgrading to 2.8 >>>>>>>- does >>>>>>>anyone know if there are db updates required since the last >>>>>>>release? >>>>>> >>>>>>The SQL for NewsFeeds needs to be run: >>>>>>/server/resources/NewsFeedResource.sql >>>>>> >>>>>>I think Aggie added QuickLinks to the upgrade code, so you >>>>>>shouldn't need to run anything for them... >>>>>> >>>>>>Colin >>>>>> >>>>>>-- >>>>>>____________________________________ >>>>>>Colin Tatham >>>>>>VLE Team >>>>>>Oxford University Computing Services >>>>>> >>>>>>http://www.oucs.ox.ac.uk/ltg/vle/ >>>>>>http://bodington.org >>>>>> >>>>>>------------------------------------------------------------------ >>>>>>-- >>>>>>-- >>>>>>--- >>>>>>Using Tomcat but need to do more? Need to support web services, >>>>>>security? >>>>>>Get stuff done quickly with pre-integrated technology to make your >>>>>>job easier >>>>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>>>>Geronimo >>>>>>http://sel.as-us.falkag.net/sel? >>>>>>cmd=lnk&kid=120709&bid=263057&dat=121642 >>>>>>_______________________________________________ >>>>>>Bodington-developers mailing list >>>>>>Bod...@li... >>>>>>https://lists.sourceforge.net/lists/listinfo/bodington-developers >>>>> >>>>> >>>>> >>>>>------------------------------------------------------------------- >>>>>-- >>>>>---- >>>>>Using Tomcat but need to do more? Need to support web services, >>>>>security? >>>>>Get stuff done quickly with pre-integrated technology to make your >>>>>job easier >>>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>>>Geronimo >>>>>http://sel.as-us.falkag.net/sel? >>>>>cmd=lnk&kid=120709&bid=263057&dat=121642 >>>>>_______________________________________________ >>>>>Bodington-developers mailing list >>>>>Bod...@li... >>>>>https://lists.sourceforge.net/lists/listinfo/bodington-developers >>>>> >>>>> >>>> >>>> >>>>-- >>>>____________________________________ >>>>Colin Tatham >>>>VLE Team >>>>Oxford University Computing Services >>>> >>>>http://www.oucs.ox.ac.uk/ltg/vle/ >>>>http://bodington.org >>>> >>>>-------------------------------------------------------------------- >>>>-- >>>>--- >>>>Using Tomcat but need to do more? Need to support web services, >>>>security? >>>>Get stuff done quickly with pre-integrated technology to make your >>>>job easier >>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>>Geronimo >>>>http://sel.as-us.falkag.net/sel? >>>>cmd=lnk&kid=120709&bid=263057&dat=121642 >>>>_______________________________________________ >>>>Bodington-developers mailing list >>>>Bod...@li... >>>>https://lists.sourceforge.net/lists/listinfo/bodington-developers >>> >>> >>> >>>--------------------------------------------------------------------- >>>---- >>>Using Tomcat but need to do more? Need to support web services, >>>security? >>>Get stuff done quickly with pre-integrated technology to make your >>>job easier >>>Download IBM WebSphere Application Server v.1.0.1 based on Apache >>>Geronimo >>>http://sel.as-us.falkag.net/sel? >>>cmd=lnk&kid=120709&bid=263057&dat=121642 >>>_______________________________________________ >>>Bodington-developers mailing list >>>Bod...@li... >>>https://lists.sourceforge.net/lists/listinfo/bodington-developers >>> >>> >> >> >>-- >>____________________________________ >>Colin Tatham >>VLE Team >>Oxford University Computing Services >> >>http://www.oucs.ox.ac.uk/ltg/vle/ >>http://bodington.org >> >>---------------------------------------------------------------------- >>--- >>Using Tomcat but need to do more? Need to support web services, >>security? >>Get stuff done quickly with pre-integrated technology to make your >>job easier >>Download IBM WebSphere Application Server v.1.0.1 based on Apache >>Geronimo >>http://sel.as-us.falkag.net/sel? >>cmd=lnk&kid=120709&bid=263057&dat=121642 >>_______________________________________________ >>Bodington-developers mailing list >>Bod...@li... >>https://lists.sourceforge.net/lists/listinfo/bodington-developers > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Bodington-developers mailing list > Bod...@li... > https://lists.sourceforge.net/lists/listinfo/bodington-developers > > -- ____________________________________ Colin Tatham VLE Team Oxford University Computing Services http://www.oucs.ox.ac.uk/ltg/vle/ http://bodington.org |
