When using scripts/backup.pl, I am getting the following message:
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` WHERE --quick': Unknown column 'quick' in 'where clause' (1054)
failed
The SQL is not created correctly. Any ideas? Thanks in advance...Dan.
Bad SQL backup [SOLVED]
Moderator: crythias
-
dstover
- Znuny advanced
- Posts: 135
- Joined: 04 Jun 2013, 23:14
- Znuny Version: 3.3.3
- Real Name: Dan Stover
- Company: EMAC, Inc.
Bad SQL backup [SOLVED]
Last edited by dstover on 17 Nov 2014, 18:41, edited 1 time in total.
OTRS 3.3.3
Ubuntu 12.04
MySQL DB
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: Bad SQL backup
These options are in the mysqldump of your /etc/mysql/my.cnf (or equivalent). Recent updates of mysql have changed valid options.
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
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
-
dstover
- Znuny advanced
- Posts: 135
- Joined: 04 Jun 2013, 23:14
- Znuny Version: 3.3.3
- Real Name: Dan Stover
- Company: EMAC, Inc.
Re: Bad SQL backup
Is there somewhere I can find the valid options? I am currently without SQL backup.
Thanks...Dan.
Thanks...Dan.
OTRS 3.3.3
Ubuntu 12.04
MySQL DB
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: Bad SQL backup
This is not an OTRS issue. Consult MySQL information.
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
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