Re: [Bodington-developers] 2.8 db updates?

[Colin T. <col...@ou...>]

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