You are not logged in.
Pages: 1
hi,
I have taken the sql dump backup of glpi 0.83.6 from one server and tried to restore it in another glpi server of the same version. I tried to restore the database through phpmyadmin, but when i trie to restore it the error pops up saying the contents below :
Error
SQL query: Documentation
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `glpi_plugin_fusinvdeploy_taskjobs` AS select `glpi_plugin_fusioninventory_taskjobs`.`id` AS `id`,`glpi_plugin_fusioninventory_taskjobs`.`plugin_fusioninventory_tasks_id` AS `plugin_fusinvdeploy_tasks_id`,`glpi_plugin_fusioninventory_taskjobs`.`entities_id` AS `entities_id`,`glpi_plugin_fusioninventory_taskjobs`.`name` AS `name`,`glpi_plugin_fusioninventory_taskjobs`.`date_creation` AS `date_creation`,`glpi_plugin_fusioninventory_taskjobs`.`retry_nb` AS `retry_nb`,`glpi_plugin_fusioninventory_taskjobs`.`retry_time` AS `retry_time`,`glpi_plugin_fusioninventory_taskjobs`.`plugins_id` AS `plugins_id`,`glpi_plugin_fusioninventory_taskjobs`.`method` AS `method`,`glpi_plugin_fusioninventory_taskjobs`.`definition` AS `definition`,`glpi_plugin_fusioninventory_taskjobs`.`action` AS `action`,`glpi_plugin_fusioninventory_taskjobs`.`comment` AS `comment`,`glpi_plugin_fusioninventory_taskjobs`.`users_id` AS `users_id`,[...]
MySQL said: Documentation
#1146 - Table 'glpi.glpi_plugin_fusioninventory_taskjobs' doesn't exist
what might be the problem, and i dont have much knowledge on sql.
Last edited by shashank101 (2012-12-24 10:04:59)
Offline
Hi
Offline
You have to install fusioninventory plugin on the other server. So the installation process would create nissed tables. The output says your database does not have them.
Offline
Pages: 1