Knowledge Base

Exporting a database dump in Plesk fails: There is not enough space on the disk

Symptoms

Attempts to generate database dumps at Plesk > Domains > example.com > Databases > Export Dump fail with the following error:

There is not enough space on the disk. (Error code 112) at Unable to copy (C:Program Files (x86)Plesktmp{0aac191a-ce66-11ea-a2d5-cd9f66e0e77c}) to (C:Inetpubvhostsexample.comgs_2020-07-25_14-57-39.sql)at (RunTime::File::copy line 1591)

Cause

Plesk bug #PPPM-12158: database dumps are duplicated during export

Resolution

Use one of the following workarounds until the bug is resolved:

Free up at least 3 times the space required to store the dump.
If for example the SQL database has a size of 6GB, have at least 18GB of free disk space on drive C:.
Create a database dump manually:
1. Connect to the server via RDP
2. Run the following command in a command-line window:
  
  “%plesk_dir%MySQLbinmysqldump.exe” -u<db_username> -p<db_password> -P3306 <database_name> > C:db_dump.sql