Forum GLPI-Project

joostr

Member

Registered: 2024-08-14

Posts: 1

mysqldump has problems with certain views

I tried a mysqldump of the glpi db

  mysqldump -u root -p glpi > glpi-sqldump.sql

and got this

  mysqldump: Got error: 1356: "View 'glpi.glpi_plugin_dataflows_destinationconnectors' references invalid table(s) or column(s) or function(s) or
  definer/invoker of view lack rights to use them" when using LOCK TABLES

after fiddling

  Got error: 1356: "View 'glpi.glpi_plugin_dataflows_deststructuretypes'
  Got error: 1356: "View 'glpi.glpi_plugin_dataflows_toauthtypes'

this gave apparently a good  mysqldump

  mysqldump --ignore-table=glpi.glpi_plugin_dataflows_destinationconnectors  --ignore-table=glpi.glpi_plugin_dataflows_deststructuretypes --ignore-table=glpi.glpi_plugin_dataflows_toauthtypes -u root -p glpi > glpi-sqldump.sql

ends with

##
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

  -- Dump completed on 2024-08-14 13:41:05

##

My question is: should I worry about not having:

glpi_plugin_dataflows_destinationconnectors
glpi_plugin_dataflows_deststructuretypes
glpi_plugin_dataflows_toauthtypes

?

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,809

Website

Re: mysqldump has problems with certain views

GLPI doesn't use views. These are from the "dataflows" plugin. If you still use that plugin, I assume they are important.

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.