-
Problem Upgrading from MySQL 5.7 to MySQL 8.0 – Agents Missing
Now that I am running Pandora 773.x, I’ve been getting a warning about upgrading MySQL from 5.7 to 8.0. I followed the instructions found here: Upgrading from MySQL 5.7 to MySQL 8 [current] (pandorafms.com)
I am running CentOS 7, so I followed that part of the instructions. All seems to go well. When I restart and browse the console, I see that users, plugins, alert actions, and alert commands are all restored. What is not restored are all of my custom remote agents and associated modules.
The only errors shown during the database restore are these:
ERROR 1054 (42S22): Unknown column ‘transactional_agent’ in ‘field list’
ERROR 1146 (42S02): Table ‘pandora.tfiles_repo’ doesn’t exist
ERROR 1146 (42S02): Table ‘pandora.tfiles_repo_group’ doesn’t exist
ERROR 1146 (42S02): Table ‘pandora.tnetwork_matrix’ doesn’t exist
ERROR 1146 (42S02): Table ‘pandora.tmetaconsole_event’ doesn’t exist
ERROR 1146 (42S02): Table ‘pandora.tmetaconsole_event_history’ doesn’t exist
Is there an extra step I’m missing?
Versions:
Version v7.0NG.773.3 – Community
MR version MR65
BuildPC230830
mysql Ver 14.14 Distrib 5.7.42-46, for Linux (x86_64) using 6.2
-
This discussion was modified 1 year, 1 month ago by
aeleus.
-
This discussion was modified 1 year, 1 month ago by
-
6 Replies
-
Hi Aeleus,
In the MySQL pre-migration backup, can you check if those tables are there?
It seems that those tables have not been created in the new DB.
If you make a pre backup of each affected table and insert it into the new DB with the MySQL source command, do you get any errors?
Best regards,
VÃc.
-
Hi Vic,
I followed the directions and used this command to backup the db before upgrading:
mysqldump -u root -p pandora –skip-add-drop-table –complete-insert –no-create-info> backup_pandora.sql
Searching backup_pandora.sql shows that all of my agents and modules are included in the dump. They are not, however, restored to the database.
-
-
-
-
