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 2019-02-07 16:37:06

ict
Guest
Registered: 2016-11-23
Posts: 26

DB Migration from MySQL (Linux) to MySQL (Windows)

Hi

I made a backup from our glpi 9.1 and imported it to our new MySQL Database (glpi 9.1 already installed). When I connect to glpi I don't have any data from the backup. Do I miss something?

thx for help

Offline

#2 2019-02-08 09:47:18

ict
Guest
Registered: 2016-11-23
Posts: 26

Re: DB Migration from MySQL (Linux) to MySQL (Windows)

Is there a tutorial how to migrate DB? Whats the different in sql backup and xml backup? sql backup is 1.3mb and xml backup is 300mb. Downloading xml backup crashes the browser though.

Offline

#3 2019-02-08 10:52:54

Langundo
Guest
Registered: 2016-07-21
Posts: 56

Re: DB Migration from MySQL (Linux) to MySQL (Windows)

Hello ict,
how do you create your database backup?
Sometimes I had some problems with dumps created by glpi webinterface.
So I decide to make my dumps with a cronjob (or manualy) and mysqldump, copy the created *.sql to the new glpi/files/_dumps and restore in most cases with webinterface of glpi. That works for me.

But generaly: Of course its your decision. why a windows sql Server ?  wink


work: Debian 9.5 - PHP 7.0.30 - MariaDB 10.1.26 - GLPI 9.3.3
test: sometimes with bugfix / master

Offline

#4 2019-02-08 13:27:11

ict
Guest
Registered: 2016-11-23
Posts: 26

Re: DB Migration from MySQL (Linux) to MySQL (Windows)

Hi Langundo

I could do now a backup directly from debian machine (after 2 hours work). Looks like the dumps created via webinterface are not working.

We want to change do Windows, because we are not good in Linux. Windows is for me a lot easier to manage. Luckly I found a nice tutorial here wink

Offline

Board footer

Powered by FluxBB