Welcome to Pandora FMS Community › Forums › Community support › Upgrade mysql from 5.7 to 8
-
Upgrade mysql from 5.7 to 8
Posted by Luca on June 14, 2024 at 10:04Hello Team,
i follow this link for update mysql https://pandorafms.com/manual/!775/en/documentation/pandorafms/technical_annexes/19_mysql_8#rocky_linux_8almalinux_8rhel_8
When i create a backup with command
mysqldump -u root -p pandora \ --skip-add-drop-table \ --complete-insert \ --no-create-info> backup_pandora.sql
and at the the end i restore this backup, there are no data.
Any suggestion?
Thanks for the support
BR
pandorafms.com
Upgrading from MySQL 5.7 to MySQL 8 [775]
Upgrading from MySQL 5.7 to MySQL 8 Prerequisites To migrate from MySQL 5.7 to MySQL 8 you must be upgraded to at least PFMS version NG 760 MR 52. * Open a terminal window with the root user and enter … Continue reading
vic replied 4 months, 3 weeks ago 3 Members · 10 Replies -
10 Replies
-
::
Hello Luca,
When you load up the backup is there any errors when sourcing the .sql file?
In case it did it means that the new database schema is not in the same version with the one you have.
In case you are migrating from one version to another, make sure to upgrade first the current database and then proceed to perform the dump again and source in the the new MySQL 8.
Kind regards,
Sergio B.
-
-
-
-
::
Hi Luca,
This is because the MySQL 8 compatible backup does not have the same data structure as the database created afterwards.
I recommend that you update the old database with the RMs to the correct version and re-extract the backup with compatibility.
Then, in the new environment, recreate the database with the schema of your version and re-insert the backup.
Best regards,
Vic. -
-
::
I follow this documentation https://pandorafms.com/manual/!775/en/documentation/pandorafms/technical_annexes/19_mysql_8#rocky_linux_8almalinux_8rhel_8.
But when reimport data generate form this command:
mysqldump -u root -p pandora \ --skip-add-drop-table \ --complete-insert \ --no-create-info> backup_pandora.sql
The agents disappears
pandorafms.com
Upgrading from MySQL 5.7 to MySQL 8 [775]
Upgrading from MySQL 5.7 to MySQL 8 Prerequisites To migrate from MySQL 5.7 to MySQL 8 you must be upgraded to at least PFMS version NG 760 MR 52. * Open a terminal window with the root user and enter … Continue reading
-
::
Hi Luca,
You have to insert MR into the old DB so that it has the same structure as the current version and recreate the MySQL 8 compatible backup.
Then, in the new environment, recreate the database with the schema of your version and re-insert the backup.
The upgrade procedure is correct, but it is necessary that both databases are on the same version of MR so that there are no problems when inserting the data.
Best regards,
VÃc. -
-
::
Hi Luca,
The implementation of the MR is in our upgrade documentation, so the migration procedure to MySQL 8 is the same.
Best regards,
VÃc.