There are several reasons for this Error:
1.No disk space left
2.Antivirus or Microsoft Security Essential blocks the file
3.Running two instances of MySQL which are trying to write the same file
4.The user running MySQL has sufficient rights on this folder
Solutions
•Rename(delete) the file •Stop MySQL, rename the file, start MySQL.
•Add the folder to the Antivirus's/Microsoft Security Essential's exclude list
•Check in the taskmanager if there are two instances running of mysql(d).
•Running defrag
•Restart Computer/MySQL
•When you have PhpMyAdmin installed, select your database, scroll down and select and click "Repair".
•When the error occurred when using mysqldump add this parameter: --skip-lock-tables and --lock-tables=false
에서
Microsoft Security Essential's exclude list <-- 문구....
댓글 13개
저도 태산입니다. ㅠㅠ
어디서 꼬인건지 ... 최적화도 별 소용이 없어요 .. ㅠㅠ
용량 확보후에
my.ini 에 이거 추가 하세여~
[mysqld]
tmp = "C:\<용량확보한곳 경로>"
윈도 불안 불안해요...
http://stackoverflow.com/questions/13069526/mysql-bug-in-php
There are several reasons for this Error:
1.No disk space left
2.Antivirus or Microsoft Security Essential blocks the file
3.Running two instances of MySQL which are trying to write the same file
4.The user running MySQL has sufficient rights on this folder
Solutions
•Rename(delete) the file •Stop MySQL, rename the file, start MySQL.
•Add the folder to the Antivirus's/Microsoft Security Essential's exclude list
•Check in the taskmanager if there are two instances running of mysql(d).
•Running defrag
•Restart Computer/MySQL
•When you have PhpMyAdmin installed, select your database, scroll down and select and click "Repair".
•When the error occurred when using mysqldump add this parameter: --skip-lock-tables and --lock-tables=false
에서
Microsoft Security Essential's exclude list <-- 문구....
즉, Defender 때문이 아닐지...
http://www.spectorsoft.com/products/eblaster_windows/help/v70/webhelp/Antivirus/Microsoft_Windows_Defender_7.htm
와 같이 Defender 띄우고 도구--> 옵션에서
제외된 파일 및 폴더에 위의 DB 디렉토리을 추가하시면 어떨까요?
혹시 해보셨다면...OTL...