NOTE: If you are creating the Weather DB from the WeatherDB-11* scripts
provided with vproweather 1.0.8 you do NOT need to do this.

It is highly recommended that you use the "script" command or pipe the 
output of the Upgrade process to a file for later review.

To upgrade the Weather DB from v10 to v11.5 you need to run the
WeatherDB_Upgrade_10_to_11.5.sql script. 

If you already upgraded your Weather DB to version 11 then you need to 
run the WeatherDB_Upgrade_11_to_11.5.sql script.

If you already upgraded your Weather DB to version 11.1 then you need to
run the WeatherDB_Upgrade_11.1_to_11.5.sql script.

If you already upgraded your Weather DB to version 11.2 then you need to
run the WeatherDB_Upgrade_11.2_to_11.5.sql script.

If you already upgraded your Weather DB to version 11.3 then you need to
run the WeatherDB_Upgrade_11.3_to_11.5.sql script.

If you already upgraded your Weather DB to version 11.4 then you need to
run the WeatherDB_Upgrade_11.4_to_11.5.sql script.

There are two ways to do the upgrade, by command line below, using 
your <admin-user> name:

# mysql -u <admin-user> -p < WeatherDB_Upgrade_10_to_11.5.sql
Enter password: 

Or from the mysql prompt:

mysql -u <admin-user> -p
Enter password: 
mysql> source WeatherDB_Upgrade_10_to_11.5.sql;
mysql> exit;

In any event you need to be in the directory where the database 
creation scripts are (where this file is located in the distribution)
because some of the Upgrade scripts call other scripts that directory.

NOTE: It may take a while for this to complete, be patient. It will
depend on how many rows are in your tables and the performance of
your computer.

The upgrade to the 11.5 version of the DB is mandatory from a
vproweather v1.0.8 standpoint. The upgrade adds columns to various
tables that contain the Console ID of the Vantage Pro Weather 
Station so that data from multiple Weather Stations can be stored
in a single database.

A stored procedure, "Reconcile_HighsLows", allows reconciliation if 
the YMD, DHL, MHL, and YHL by date if necessary. To use the 
"Reconcile_HighsLows" stored procedure:

mysql> CALL Reconcile_HighsLows(YYYYMMDD);

Where YYYYMMDD is the Year Month and Day you would like to reconcile.
On a AMD Phenom 945 with 8G of memory and a caching raid controller it 
takes about 2-1/2 minutes to reconcile a full day so be patient.





