Forum GLPI-Project

a.hassen

Member

Registered: 2013-09-16

Posts: 11

Mysql 5.5 ->

Bonjour à tous,

Comment migrer une base de données GLPI 0.80.7 "windows" , vers une machine Debian avec une base de données mysql 5.5 version glpi 0.84.2 ?

Merci à vous

a.hassen

Member

Registered: 2013-09-16

Posts: 11

Re: Mysql 5.5 ->

Et si oui comment svp

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Re: Mysql 5.5 ->

en passant par une sauvegarde logique (mysqldump) puis un rechagrement (mysql)

---

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

a.hassen

Member

Registered: 2013-09-16

Posts: 11

Re: Mysql 5.5 ->

Merci, mais j'ai cette erreur ...

Traitement en cours...
Mise à jour en 0.83
Migration de données - Create new default profiles (2 secondes)
glpi_groups_problems table already exists. A backup have been done to backup_glpi_groups_problems.
glpi_items_problems table already exists. A backup have been done to backup_glpi_items_problems.
glpi_problems table already exists. A backup have been done to backup_glpi_problems.
glpi_problemtasks table already exists. A backup have been done to backup_glpi_problemtasks.
glpi_problems_users table already exists. A backup have been done to backup_glpi_problems_users.
glpi_ticketrecurrents table already exists. A backup have been done to backup_glpi_ticketrecurrents.
glpi_tickettemplates table already exists. A backup have been done to backup_glpi_tickettemplates.
glpi_tickettemplatehiddenfields table already exists. A backup have been done to backup_glpi_tickettemplatehiddenfields.
glpi_tickettemplatemandatoryfields table already exists. A backup have been done to backup_glpi_tickettemplatemandatoryfields.
glpi_tickettemplatepredefinedfields table already exists. A backup have been done to backup_glpi_tickettemplatepredefinedfields.
glpi_useremails table already exists. A backup have been done to backup_glpi_useremails.
You can delete backup tables if you have no need of them.
0.83 create new profile hotliner - Erreur durant l'éxecution de la requête : INSERT INTO `glpi_profiles` (`name`, `interface`, `user`, `import_externalauth_users`, `create_ticket`, `assign_ticket`, `global_add_followups`, `add_followups`, `update_ticket`, `observe_ticket`, `show_all_ticket`, `show_full_ticket`, `show_all_problem`, `show_planning`, `statistic`, `tickettemplate`, `password_update`, `helpdesk_hardware`, `helpdesk_item_type`, `create_validation`, `update_own_followups`, `create_ticket_on_login`) VALUES ('Hotliner', 'central', 'r', 'w', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', 'r', '1', '3', '[\"Computer\", \"Monitor\", \"NetworkEquipment\",\"Peripheral\", \"Phone\", \"Printer\",\"Software\"]', '1', '1', '1') - L'erreur est Unknown column 'create_validation' in 'field list'

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Mysql 5.5 ->

Vous ne pouvez pas importer une base GLPI 0.80.7 dans une 0.84.2.
En effet, les champs ont changés.
Il faut migrer votre base 0.80.7 en 0.84.2 et ensuite vous pourrez l'importer

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

a.hassen

Member

Registered: 2013-09-16

Posts: 11

Re: Mysql 5.5 ->

Merci Yllen de votre réponse,

Même en important d'une version 0.80.7 -> 0.80.7 ... la restauration s’arrête à 35% ... avec toujours le même message d'erreur ... alors je ne sais plus trop que faire .... :'(

Last edited by a.hassen (2013-09-30 13:33:11)