You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2012-12-24 08:50:30

shashank101
Guest
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)

Offline

#2 2012-12-26 17:05:58

sgeorge
Guest
From: Ukraine
Registered: 2010-02-18
Posts: 85

Re: unable to import the sql dump

Hi

Offline

#3 2012-12-26 17:07:43

sgeorge
Guest
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.

Offline

Board footer

Powered by FluxBB