Problem Upgrading from MySQL 5.7 to MySQL 8.0 – Agents Missing

[vic]

Like it

Up

0

Down

Drop it

::

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.

[aeleus]

Like it

Up

0

Down

Drop it

::

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.

[aeleus]

Like it

Up

0

Down

Drop it

::

[I’m posting in short segments because the forum won’t work otherwise]

This is the sequence of commands I use to restore based on the documentation:

mysql -u root -p pandora

drop database pandora;

[takes a minute]

[Create a new pandora database]

create database pandora;

[aeleus]

Like it

Up

0

Down

Drop it

::

[Open the pandora database and import the schema found in the PFMS Web Console]

use pandora;

source /var/www/html/pandora_console/pandoradb.sql;

[takes a while]

[Import the data that special MySQL 8 compatible backup]

source backup_pandora.sql;

[takes a while]

[aeleus]

Like it

Up

0

Down

Drop it

::

[Forum wouldn’t let me post the last few lines, but they came right from the documentation]

CREATE USER …

ALTER USER …

GRANT ALL PRIVILEGES …

flush privileges …

exit and reboot

[aeleus]

Like it

Up

0

Down

Drop it

::

Vic,

Can you explain what you mean by, “make a pre backup of each affected table and insert it into the new DB with the MySQL source command”? Isn’t that what I’m doing with the mysqldump command?