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 2011-07-14 07:41:48

KKAdmin
Member
From: Germany
Registered: 2010-03-05
Posts: 959

Backup size cron job vs glpi

Why is the backup with a cron job smaller then the backup with glpi interface ?

CronJob Backup:
2011-07-14.glpi.backup.sql      1716 kB       2011-07-14 00:10     Löschen      Wiederherstellen      öffnen/herunterladen
2011-07-13.glpi.backup.sql      1716 kB       2011-07-13 21:28     Löschen      Wiederherstellen      öffnen/herunterladen

Backup with GLPI Inteface
glpi-0.80.1-2011-07-13-21-26.sql      2378 kB       2011-07-13 21:26     Löschen      Wiederherstellen      öffnen/herunterladen

Cron job script:
mysqldump -u $myuser -p$mypass --opt glpidb > /var/www/glpi/files/_dumps/$date.glpi.backup.sql


You can mark this threat as [resolved] in subject of your threat. (This is only available edit of the first post.) It is good for users who help others to quickly see which post is still open.
##############################################
GLPI 9.3.3

Offline

#2 2011-07-14 10:45:08

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: Backup size cron job vs glpi

Because datas are not exporting using the same syntax.
INSERT maybe done in one line for all or one line per entry for example.

Prefer to you cron jobs to do that.
A clean tool named automysqlbackup is very interesting for that.


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

Board footer

Powered by FluxBB