Article ID: 127463, created on Nov 18, 2015, last review on Aug 21, 2016

  • Applies to:
  • Plesk 12.5 for Windows


Database backup fails:

[WARNING]: Cannot dump database content 'example_db-134' of type 'mysql'[Cannot backup content of database 'example_db-134'. The mysqldump utility has returned '7'.
STDERR: mysqldump: unknown variable 'defaults-extra-file=C:\Program Files (x86)\Parallels\Plesk\PrivateTemp\tmp60912.tmp'

It is not possible to create a dump of the database including routines:

C:\> "%plesk_bin%\BackupUtils\mysqldump.exe" -Q -hlocalhost -uexample-user -p********* -P3306 --routines example_db-134 > "C:\Program Files (x86)\Parallels\Plesk\PrivateTemp\tmp26598.tmp
Warning: Using a password on the command line interface can be insecure.
mysqldump: Couldn't execute 'SHOW FIELDS FROM `example_table`': execute command denied to user 'example-user'@'%' for routine 'example_db-134.example_routine' (1370)


Insufficient privileges.


  1. Go to MySQLAdmin and set Grant, Execute privileges for the user to the database mentioned in the error message.

  2. Contact the database owner to optimize the permissions.

Search Words

execute command denied to user

STDERR: mysqldump: unknown variable

mysqldump: Couldn't execute 'SHOW FIELDS

command denied to user

mysqldump: unknown variable

8b661cab116c79dbe6c4ac5bbdf1c8cb 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8

Email subscription for changes to this article
Save as PDF