Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.12.3 available

The official documentation can be found on https://wiki.ocsinventory-ng.org. Read it before asking your question.

can't export database

I export from a linux serveur database with phpmyadmin

 

the idea is to have a backup of the data and can be restore theses

 

i have try to import the files sql on a wibndows serveur but i can't and got error message each time even with differents parameters when i export from linux ocsinventory server

have you and idea for the right parameters ?

example of erreor message

#1054 - Unknown column 'fields_3' in 'field list'

 

-- -- Base de données : `ocsweb` -- -- -- Contenu de la table `accountinfo` -- INSERT INTO `accountinfo` (`HARDWARE_ID`, `TAG`, `fields_3`) VALUES (1, 'DEBILLE', NULL), (2, 'DEBILLE', NULL), (3, 'DEBILLE', NULL), (4, 'DEBILLE', NULL), (5, 'DEBILLE', NULL), (6, 'DEBILLE', NULL), (7, 'DEBILLE', NULL), (8, 'DEBILLE', NULL), (9, 'DEBILLE', NULL), (10, 'DEBILLE', NULL), (11, 'DEBILLE', NULL), (12, 'DEBILLE', NULL), (13, 'DEBILLE', NULL), (14, 'SNL91_DN', NULL), (15, 'SNL91_RS', NULL), (16, 'SNL91_AN', NULL), (17, 'SNL91_AN', NULL), (18, 'SNL91', NULL), (19, 'SNL91', NULL), (20, 'SNL91', NULL), (21, 'SNL91', NULL), (22, 'SNL91', NULL), (23, 'SNL91', NULL), (24, 'SNL91', NULL), (25, 'SNL91', NULL), (26, 'SNL91', NULL), (27, 'SNL91', NULL), (28, 'SNL91', NULL), (29, 'SNL91', NULL), (30, 'SNL91', NULL), (31, 'SNL91', NULL), (32, 'SNL91', NULL), (33, 'SNL91', NULL), (34, 'SNL91_PS2', NULL), (35, 'SNL91_PS1', NULL), (36, 'SNL91_PS1', NULL), (37, 'SNL91_PS1', NULL), (38, 'SNL91_MY', NULL), ([...]
in Administrative console by (1.5k points)

1 Answer

0 votes
I found a solution

 

export with create database

import with a database empty on the new serveur

connect to it ! ocs tell me it  want to install ?? i said yes .. and ocs upgrade database without deleting any data and i can use it !! great
by (1.5k points)
 
Powered by Question2Answer
...