1 (edited by shashank101 2012-12-24 10:04:59)

Topic: 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.

2

Re: unable to import the sql dump

Hi

3

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.