Winston: Jar update; Moving DBase

[Meremonte, Mark E]

Have Winston DBase where serving waveforms fails intermittently.   To resolve must restart process gov.usgs.winston.server.WWS.  Tried updating just the jar file from current Winston app available at https://volcanoes.usgs.gov/software/.  However, this does not resolve issue.  Is it necessary to reinstall Winston DBase.  If so, will the current DBase remain intact?

And 2nd related question:   Need to move Winston DBase to a different VM.   If build Winston on new VM, can the old DBase be migrated over to new Winston and continue to import/add new data?

Thank you,

Mark 

***************************************************************

Mark Meremonte    Geophysicist  

mmere...@usbr.gov  o: 303-445-3298  c: 303-808-3894 

US Bureau of Reclamation   http://www.usbr.gov

Technical Services Center, Seismology & Geomorphology Group

Denver Federal Center,  PO Box 25007, 85-833000, Denver, CO  80225                  

Ship:  US Bureau of Reclamation, DFC, Bldg. 67-10th Floor, Denver, CO 80225

***************************************************************

[Victor Preatoni]

Hi Mark,

Regarding your 2nd question, yes, you can do that. Keep in mind that it can be a very tedious process, depending on how many channels and how many years of data storage u have.

From your new server, run the following command:

mysqldump --single-transaction --quick --skip-lock-tables -h IP.ADDRESS.OF.OLD.SERVER -u oldServerSQLuser -pOldServerSQLpass 'W_SSS$CCC$NN$LL'>'W_SSS$CCC$NN$LL.sql'

* Old server SQL instance must allow remote connections. Change my.conf accordingly

** Replace IP address, user and password with the right ones

*** Replace SSS CCC NN LL with the SCNL format of your channels. You will have to run this command for every channel you have!. 

After command execution, you will have a huge .SQL file which you have to import into your new SQL instance:

mysql -D'W_SSS$CCC$NN$LL'<'W_SSS$CCC$NN$LL.sql'

Good luck!