Hi,
is there some howto available to move my weewx mysql database to a new
weewx machine (now 4.1.1 on Python3). I'm not sure howto migrate the
databse and do the transition as smooth as possible?
I noticed that there are a lot of new and additional entries in
wview_extended.py which weren't available on my Python2 machine I run for
years now. :-)
I added some entries there and see they are now available ( in parts) in
the new weewx 4 scheme?
I would be pleased if I can move the adatabase or import the main values
like temp, hum at first place and as a minimum to my new setup?
I will not change the hardware (still VP2), just move the database and the
VP2 to a new machine with weewx 4 and will use a new skin.
Is there an utility to merge the old weewx database (Mysql) in the new one
on the new machine from a backup?
Will it insert the data of equal fields in the right way!?
Sorry...im not very familiar with mysql but it would ne nice not to loose
data from now 6 years and beginn with a blank database.
Thanks for any help!
Regards,
Christian
my "old" wview_extended.py (3.9.):
schema = [('dateTime', 'INTEGER NOT NULL UNIQUE PRIMARY KEY'),
('usUnits', 'INTEGER NOT NULL'),
('interval', 'INTEGER NOT NULL'),
('barometer', 'REAL'),
('pressure', 'REAL'),
('altimeter', 'REAL'),
('inTemp', 'REAL'),
('outTemp', 'REAL'),
('inHumidity', 'REAL'),
('outHumidity', 'REAL'),
('windSpeed', 'REAL'),
('windDir', 'REAL'),
('windGust', 'REAL'),
('windGustDir', 'REAL'),
('rainRate', 'REAL'),
('rain', 'REAL'),
('dewpoint', 'REAL'),
('windchill', 'REAL'),
('heatindex', 'REAL'),
('ET', 'REAL'),
('radiation', 'REAL'),
('UV', 'REAL'),
('extraTemp1', 'REAL'),
('extraTemp2', 'REAL'),
('extraTemp3', 'REAL'),
('soilTemp1', 'REAL'),
('soilTemp2', 'REAL'),
('soilTemp3', 'REAL'),
('soilTemp4', 'REAL'),
('leafTemp1', 'REAL'),
('leafTemp2', 'REAL'),
('extraHumid1', 'REAL'),
('extraHumid2', 'REAL'),
('soilMoist1', 'REAL'),
('soilMoist2', 'REAL'),
('soilMoist3', 'REAL'),
('soilMoist4', 'REAL'),
('leafWet1', 'REAL'),
('leafWet2', 'REAL'),
('rxCheckPercent', 'REAL'),
('txBatteryStatus', 'REAL'),
('consBatteryVoltage', 'REAL'),
('hail', 'REAL'),
('hailRate', 'REAL'),
('heatingTemp', 'REAL'),
('heatingVoltage', 'REAL'),
('supplyVoltage', 'REAL'),
('referenceVoltage', 'REAL'),
('windBatteryStatus', 'REAL'),
('rainBatteryStatus', 'REAL'),
('outTempBatteryStatus', 'REAL'),
('inTempBatteryStatus', 'REAL'),
('cpm', 'REAL'),
('cps', 'REAL'),
('geiger', 'REAL'),
('PM10_1', 'REAL'),
('PM10_2', 'REAL'),
('PM25_1', 'REAL'),
('PM25_2', 'REAL'),
('tmp_dt_1', 'REAL'),
('tmp_dt_2', 'REAL'),
('hum_dt_1', 'REAL'),
('hum_dt_2', 'REAL')]
and the wview_extended.py (4.1):
table = [('dateTime', 'INTEGER NOT NULL UNIQUE PRIMARY KEY'),
('usUnits', 'INTEGER NOT NULL'),
('interval', 'INTEGER NOT NULL'),
('altimeter', 'REAL'),
('appTemp', 'REAL'),
('appTemp1', 'REAL'),
('barometer', 'REAL'),
('batteryStatus1', 'REAL'),
('batteryStatus2', 'REAL'),
('batteryStatus3', 'REAL'),
('batteryStatus4', 'REAL'),
('batteryStatus5', 'REAL'),
('batteryStatus6', 'REAL'),
('batteryStatus7', 'REAL'),
('batteryStatus8', 'REAL'),
('cloudbase', 'REAL'),
('co', 'REAL'),
('co2', 'REAL'),
('consBatteryVoltage', 'REAL'),
('dewpoint', 'REAL'),
('dewpoint1', 'REAL'),
('ET', 'REAL'),
('extraHumid1', 'REAL'),
('extraHumid2', 'REAL'),
('extraHumid3', 'REAL'),
('extraHumid4', 'REAL'),
('extraHumid5', 'REAL'),
('extraHumid6', 'REAL'),
('extraHumid7', 'REAL'),
('extraHumid8', 'REAL'),
('extraTemp1', 'REAL'),
('extraTemp2', 'REAL'),
('extraTemp3', 'REAL'),
('extraTemp4', 'REAL'),
('extraTemp5', 'REAL'),
('extraTemp6', 'REAL'),
('extraTemp7', 'REAL'),
('extraTemp8', 'REAL'),
('forecast', 'REAL'),
('hail', 'REAL'),
('hailBatteryStatus', 'REAL'),
('hailRate', 'REAL'),
('heatindex', 'REAL'),
('heatindex1', 'REAL'),
('heatingTemp', 'REAL'),
('heatingVoltage', 'REAL'),
('humidex', 'REAL'),
('humidex1', 'REAL'),
('inDewpoint', 'REAL'),
('inHumidity', 'REAL'),
('inTemp', 'REAL'),
('inTempBatteryStatus', 'REAL'),
('leafTemp1', 'REAL'),
('leafTemp2', 'REAL'),
('leafWet1', 'REAL'),
('leafWet2', 'REAL'),
('lightning_distance', 'REAL'),
('lightning_disturber_count', 'REAL'),
('lightning_energy', 'REAL'),
('lightning_noise_count', 'REAL'),
('lightning_strike_count', 'REAL'),
('luminosity', 'REAL'),
('maxSolarRad', 'REAL'),
('nh3', 'REAL'),
('no2', 'REAL'),
('noise', 'REAL'),
('o3', 'REAL'),
('outHumidity', 'REAL'),
('outTemp', 'REAL'),
('outTempBatteryStatus', 'REAL'),
('pb', 'REAL'),
('pm10_0', 'REAL'),
('pm1_0', 'REAL'),
('pm2_5', 'REAL'),
('pressure', 'REAL'),
('radiation', 'REAL'),
('rain', 'REAL'),
('rainBatteryStatus', 'REAL'),
('rainRate', 'REAL'),
('referenceVoltage', 'REAL'),
('rxCheckPercent', 'REAL'),
('signal1', 'REAL'),
('signal2', 'REAL'),
('signal3', 'REAL'),
('signal4', 'REAL'),
('signal5', 'REAL'),
('signal6', 'REAL'),
('signal7', 'REAL'),
('signal8', 'REAL'),
('snow', 'REAL'),
('snowBatteryStatus', 'REAL'),
('snowDepth', 'REAL'),
('snowMoisture', 'REAL'),
('snowRate', 'REAL'),
('so2', 'REAL'),
('soilMoist1', 'REAL'),
('soilMoist2', 'REAL'),
('soilMoist3', 'REAL'),
('soilMoist4', 'REAL'),
('soilTemp1', 'REAL'),
('soilTemp2', 'REAL'),
('soilTemp3', 'REAL'),
('soilTemp4', 'REAL'),
('supplyVoltage', 'REAL'),
('txBatteryStatus', 'REAL'),
('UV', 'REAL'),
('uvBatteryStatus', 'REAL'),
('windBatteryStatus', 'REAL'),
('windchill', 'REAL'),
('windDir', 'REAL'),
('windGust', 'REAL'),
('windGustDir', 'REAL'),
('windrun', 'REAL'),
('windSpeed', 'REAL'),
]
day_summaries = [(e[0], 'scalar') for e in table
if e[0] not in ('dateTime', 'usUnits', 'interval')] +
[('wind', 'VECTOR')]
schema = {
'table': table,
'day_summaries' : day_summaries
}
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/63597f2a-1e95-4a14-b02c-07da087b79aao%40googlegroups.com.
