WD and the SQL Database Setup

I’ve read the file readmedatabase.txt. The first thing it says is to download the WDdatabase program. I’ve looked at the web site download section and cannot find anything with that name. I’m using version 10.37R build 80. Just need a little help!

Jim

Hi,

At first I would suggest updating to latest version of WD. Mods
have been made since your vers. regarding mySQL.

After, Control Panel → MYSQL Database

There, set up paramters for your mySQL database. Ringt buton on ‘On’, Save.

Next clion Run the wdmysql.exe program now

Depending on the Windows version you have, you can
access this program any time if running, n the bottom left of your screen
the little up triangle, left clic, you should seen an icon kind of vertical blue tube (barrel).
Left clic and choose show.

You shouls now have the WDMYSQL vers 10.7 showing.

Do what you wish, but. DO NOT use ‘Setup custom’ it does NOT work.

Hope it help.

Other solution writing your own php script to maintain a mySQL data base
structured as you wish and getting data from your testtags.php file.
Run as cron job every xx minutes.

Regards.

-= Guy =-

@ [email protected]
that is the for the MS Database , which is old technology
the download link is
http://www.weather-display.com/downloadfiles/wddatabasesetup.zip

as suggested you might be better to use the MYSQL support

Brian,
The setup does not work on newer versions of Windows.
Is there a more recent version?
Also, where can I find reliable documentation for using MySQL to store WD data?

Installed MySQL v8.0
Created an empty database named wdmysql
Created a user and granted all privileges to database wdmysql
Launched WDMYQL v. 10.7 from Control Panel

Status in WDMYSQL:
Login OK to localhost
Database wdmysql opened OK

When click on “Create table” I get the error : SELECT command denied to user ‘xxx’@‘localhost’ for table ‘weatherdata’

1 - Any hints on what can be wrong?
2 - I can create the table myself, but I will need documentation of the schema. Where can I find this?

that sounds like a permissions problem
if you can create the table yourself, then I would do that

what is with all the grave digging pots?

It is no digging for anything, just polite asking for documentation of table structure etc. that can help us to get going storing our data in MySQL.

Forum “gravedigging” refers to re-opening old threads. It would be easier to keep up with your questions if you started a new thread and continued to address your issues in one place.

Difficult one. Members are advised to search the forum for answers before posting, so may cotton on to an old thread. And if we post a new thread without searching we are often told the problem was solved way back when. . .

If the old thread had the solution there would be no reason to re-open it…

And if it had, wouldn’t it be better to share that information instead of serving vague hints?