zqr10159 commented on PR #1801: URL: https://github.com/apache/hertzbeat/pull/1801#issuecomment-2071689784
> **upgrade this attention.** If you use an empty database, there is no need to upgrade. > > 1. Export Import Method (suggest) > > export the all monitoring, export all alarm rules, and deploy start a new one system, import them. > > 2. Database Method > > edit the h2 database columns, if use mysql, change the mysql columns > > ``` > ALTER TABLE HZB_PARAM ALTER COLUMN "value" RENAME TO param_value; > > ALTER TABLE HZB_TAG ALTER COLUMN "value" RENAME TO tag_value; > > ALTER TABLE HZB_STATUS_PAGE_HISTORY ALTER COLUMN "unknown" RENAME TO unknowing; > ``` > > start the system. > > edit the save all notice rule in web, disable and enable them. The mysql 5.7 version is not able to execute these sql's and I think upgrading these is best for the user not to operate, can we find a better way? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
