15,041
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Error!: SQLSTATE[HY000]: General error: 3 Error writing file 'xxx\Temp\xxx.tmp' (Errcode: 28 - No space left on device)
| Line 130: | Line 130: | ||
Open the command line with administrative privileges. (How to: [https://www.howtogeek.com/194041/how-to-open-the-command-prompt-as-administrator-in-windows-8.1/ How to Open the Command Prompt as Administrator in Windows 8 or 10]) | Open the command line with administrative privileges. (How to: [https://www.howtogeek.com/194041/how-to-open-the-command-prompt-as-administrator-in-windows-8.1/ How to Open the Command Prompt as Administrator in Windows 8 or 10]) | ||
== Error!: SQLSTATE[HY000]: General error: 3 Error writing file | === Error!: SQLSTATE[HY000]: General error: 3 Error writing file xxx.tmp (Errcode: 28 - No space left on device) === | ||
Example error message: Error!: SQLSTATE[HY000]: General error: 3 Error writing file 'C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp\MY2713.tmp' (Errcode: 28 - No space left on device) | Example error message: Error!: SQLSTATE[HY000]: General error: 3 Error writing file 'C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp\MY2713.tmp' (Errcode: 28 - No space left on device) | ||
| Line 149: | Line 149: | ||
Validation | Validation | ||
* Query the syntax {{kbd | key=<nowiki>SHOW VARIABLES LIKE 'tmpdir';</nowiki>}} to validate the modification of mysql configuration file. | * Query the syntax {{kbd | key=<nowiki>SHOW VARIABLES LIKE 'tmpdir';</nowiki>}} to validate the modification of mysql configuration file. | ||
== mysqldump: Got errno 32 on write == | == mysqldump: Got errno 32 on write == | ||