Cannot create a database dump: Got errno 28 on write

Created:

2017-07-20 14:08:17 UTC

Modified:

2017-08-16 16:31:57 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot create a database dump: Got errno 28 on write

Applicable to:

  • Plesk for Linux

Symptoms

  1. Debug log shows in /var/log/plesk/panel.log the following:
    DEBUG [panel] PleskUtilException: mysqldump: Got errno 28 on write
  2. Free space in /tmp is less than a database size

Cause

Insufficient amount of space in /tmp

Resolution

Increase the amount of free space in /tmp .

As a workaround, it is possible to change the location of tmpdir for MySQL and set the variable DUMP_TMP_D in /etc/psa/psa.conf to the same value:

# cat /etc/my.cnf | grep tmpdir
tmpdir = /var/tmp
# cat /etc/psa/psa.conf | grep TMP DUMP_TMP_D /var/tmp
Have more questions? Submit a request
Please sign in to leave a comment.