Upload data from second WC install to MySQL

[monymony]

OK, I admit this is a strange one...

I want to be able to use the createNOAA.php and createClimate.php scripts (http://athena.trixology.com/index.php?topic=1096.msg9220#msg9220) so that I can create the files needed for some of the website php history pages (such as http://www.cecilweather.com/wxtempdetail.php and http://www.cecilweather.com/wxnoaarecords.php).  This all works fine on my site and has for sometime, but now I am helping my father put his WeatherCat information online and need to repeat this procedure.  The problem is he does not have MySQL installed nor do we plan on setting this up on his Mac.  So this leads me to try and figure out how to create a temporary database on my system to try and upload the data to ultimately have in a format that I can run those scripts. 

Bottom line... has anyone tried to link WC to a different dataset?  I am thinking if I get all of the *.cat files from the other installation, backup my live data, restore the files from the other install and then have WC upload to MySQL it should in theory work but I have no idea what pitfalls I might run into.  I am also open to other suggestions too so if anyone has any ideas please let me know.

Thanks as always!

Jay

[elagache]

Hi Jay and WeatherCat tinkerers,

OK, I admit this is a strange one...

Yes, that's one way to put it! 

Bottom line... has anyone tried to link WC to a different dataset?  I am thinking if I get all of the *.cat files from the other installation, backup my live data, restore the files from the other install and then have WC upload to MySQL it should in theory work but I have no idea what pitfalls I might run into.  I am also open to other suggestions too so if anyone has any ideas please let me know.

The only thing I'm aware of is moving WeatherCat from one machine to another.  Here is the Wiki entry about it:

http://wiki.trixology.com/index.php/Moving_a_WeatherCat_installation_from_one_computer_to_another

This is known to work.  It isn't exactly what you are describing, but at least it is a point of departure.

Sorry, indeed you are doing something very few others are exploring.

Edouard

[monymony]

Hi Edouard,

Actually that link does help.  I was already thinking I would be dealing with the ~/Library/WeatherCatData directory anyway. 

The only thing I'm aware of is moving WeatherCat from one machine to another.  Here is the Wiki entry about it:

This should make for a fun project but seeing that link I think I can pull off what I need to do, especially now knowing what files I need to backup first! 

Thanks!

Jay

[monymony]

Hi All,

If anyone cares I was able to do this procedure.  The only surprise is apparently WC won't upload to SQL unless it is actively receiving data from a station.  Otherwise it was uneventful.    Thanks again to AstroSteve for creating the scripts a while back.

Jay