On further inspection the table created in the updated machine was a single table with 114 columns; the tables created in the older version sql database appears to be 114 separate archive tables.
Is Vers 4 supposed to create the needed mysql database tables on install the same as the previous vers of weewx did on install? so before installing weewx just creatie an empty database weewx with weewx userID and weewx PW? Clearly a good reason why problems occurring when table structures are incorrect. 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/1458064d-3457-4bff-bf00-918f9d84d597%40googlegroups.com.
