Forum GLPI-Project

shashank101

Member

Registered: 2012-10-27

Posts: 2

unable to import the sql dump

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)

sgeorge

Member

From: Ukraine

Registered: 2010-02-18

Posts: 85

Re: unable to import the sql dump

Hi

sgeorge

Member

From: Ukraine

Registered: 2010-02-18

Posts: 85

Re: unable to import the sql dump

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.