Thanks for your help. I'll give it a try.

From: Louis Munro [mailto:[email protected]]
Sent: Tuesday, November 25, 2014 8:58 AM
To: [email protected]
Subject: Re: [PacketFence-users] upgrade 4.0.1 to 4.5.1

On 2014-11-25, at 9:25 , "Fabrice Durand" 
<[email protected]<mailto:[email protected]>> wrote:


Hello,

in the db directory you have all the upgrade-...sql files.
So:
mysql -u root -p pf -v < upgrade-4.0.0-4.1.0.sql
mysql -u root -p pf -v < upgrade-42.0 ....



To add to what Fabrice has already written, the database upgrade files are just 
text files with some sql.

You could just concatenate the files using the much abused "cat" and get a 
single file to run:

# cat db/upgrade-4* >> upgrade-4.0-4.5.sql

And then you'd have an upgrade-4.0-4.5.sql  file that you can apply:

# mysql -u root -p pf < upgrade-4.0-4.5.sql


The only other way you could upgrade without running those schema changes would 
be to reinstall from scratch.

Regards,
--
Louis Munro
[email protected]<mailto:[email protected]>  ::  
www.inverse.ca<http://www.inverse.ca>
+1.514.447.4918 x125  :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu<http://www.sogo.nu>) and 
PacketFence (www.packetfence.org<http://www.packetfence.org>)


------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to