Dear Christian, I did it with your scripts, which I find good, and got the same result : Erreur: Need SystemAddressID! when trying to modify any option of any queue (name, subqueue, group, options and so on...). This should meen that the backups are OK, but the database is corrupted... What this message meens? How could I repair this problem? Many thanks in advance for any light, Philippe Roth

Date: Thu, 16 Jun 2005 18:03:55 +0200 From: Christian Schoepplein Subject: Re: [otrs] Please need HELP... To: "User questions and discussions about OTRS.org" Message-ID: <20050616160353.GB10078@jvc-schoeppi.schoeppi.net> Content-Type: text/plain; charset="us-ascii"

Hi Phillippe,

On Thu, Jun 16, 2005 at 05:17:16PM +0200, Philippe Roth wrote:

...

I think our database is corrupted {:o(

Maybe the problem is the way I make the dumps... I use mysqldump --add-drop-table -u root -p otrs > otrs.bkp

Take a look into the scripts directory in your otrs installation. There

you'll find a backupscript called backup.sh. And there is also a restore.sh script.

Best regards, Christian