Error in Plesk interface: SQLSTATE[HY000]: General error: 1 Can't create/write to file 'C:\Program Files (x86)\Parallels\Plesk\MySQL\Data\#sqlc7c_74_0.MYI' (Errcode: 22)

Created:

2017-03-23 14:08:41 UTC

Modified:

2017-08-08 13:44:19 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error in Plesk interface: SQLSTATE[HY000]: General error: 1 Can't create/write to file 'C:\Program Files (x86)\Parallels\Plesk\MySQL\Data\#sqlc7c_74_0.MYI' (Errcode: 22)

Applicable to:

  • Plesk for Windows

Symptoms

  • The following error is shown in Plesk interface:

    SQLSTATE[HY000]: General error: 1
    Can't create/write to file 'C:\Program Files (x86)\Parallels\Plesk\MySQL\Data\#sqlc7c_74_0.MYI' (Errcode: 22)
  • It is not possible to create backup of psa database:

    C:\Program Files (x86)\Parallels\Plesk\MySQL\bin>mysqldump -uadmin -p"c7cHLE&Je$*cGVmj72vA" -P8306 psa > "C:\Program Files (x86)\Parallels\Plesk\MySQL\Backup\psa.support.sql"
    The file or directory is corrupted and unreadable.

Cause

Corrupted C:\ drive.

Resolution

  1. Change tmpdir to another disk in the C:\Program Files (x86)\Parallels\Plesk\MySQL\Data\my.ini file, for example: tmpdir=E:\\mysqltmp .

  2. Check C:\ disk with the command:

    chkdsk /f C:
    
Have more questions? Submit a request
Please sign in to leave a comment.