I use mysql because I am familiar with it. I managed to get weewx ver 4 communicate with ACUrite display unit ptoper and with no logged errors. I was able to create a database named "weewx" with a new empty table with 114 columns named as posted here in this group post. I created the weewx user with password weewx on that database. I was able to log into the database using that userID and PW to verify the existence of the proper empty table which of course proves weewx ver 4 shud be able to log in and update the database; but it does not do it. Why I do not know. I purged all of weewx and re-installed it fresh to ensure it had not missed an initial connection to the database during the install process. To no avail; I have moved the display unit back onto the machine running linux 18.04lts instead of the currently available 20.04, and it is running weewx older version; BUT IT WORKS properly.
On Sunday, May 17, 2020 at 8:07:46 PM UTC-5, VE4PER / Andy wrote: > > Hello, > > I did an export database from old mysql db using phpmyadmin. I copied the > weewx.sql file over to the new machine and tried to import data into the > empty weewx database using phpmyadmin. I kept getting errors on import; I > amend UPLOAD_MAX POST_MAX to 64MB and also doubled time to 60 from 30 but > still generating errors size is 55.4 MB for weewx.sql file; zipped it is > 8.1 MB but neither will import using phpmyadmin. > > Tried using mysql command line and all it seems to do is generate command > syntax errors. took commands from examples in mysql ref manual for vers 8 > > I have system down for a number of hours now and unable to get old data in > to create the required archive table so info not being sent to remote > users. Usually in the past, if I remove /uninstall weewx and then reinstall > it from scratch it created the mysql database and tables ; doesn't now > though. > > Any tips or pointers would be appreciated > > Thanks > Andy > -- 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/674b0c35-78e3-42a6-99ce-94dc6d2a7538%40googlegroups.com.
