OTRS backup on new VM failed [SOLVED]

Moderator: crythias

Locked
dstover
Znuny advanced
Posts: 135
Joined: 04 Jun 2013, 23:14
Znuny Version: 3.3.3
Real Name: Dan Stover
Company: EMAC, Inc.

OTRS backup on new VM failed [SOLVED]

Post by dstover »

I have moved my OTRS system to a new virtual machine and am trying to backup and am receiving the following message:

Code: Select all

otrs@OTRS2:/root$ /opt/otrs/scripts/backup.pl -d /var/otrs-backup/
Backup /var/otrs-backup//2014-08-28_14-27/Config.tar.gz ... done
Backup /var/otrs-backup//2014-08-28_14-27/Application.tar.gz ... done
Dump MySQL rdbms ... Warning: Using unique option prefix w instead of where is deprecated and will be removed in a future release. Please use the full name instead.
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `acl_sync` WHERE --quick': Unknown column 'quick' in 'where clause' (1054)
failed
Does anyone have any advice on what is the issue?

Thanks...Dan.
Last edited by dstover on 17 Nov 2014, 18:42, edited 1 time in total.
OTRS 3.3.3
Ubuntu 12.04
MySQL DB
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: OTRS backup on new VM failed

Post by crythias »

mysqldump is called with default options.
check /etc/mysql/my.conf
[mysqldump]

This issue is related to configuration of mysqldump which may be outside the scope of OTRS unless this is an OTRS Appliance.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked