php中的MySql错误
问题描述：
I have used Joomla 2.5 and the administrator module manager displays this type of error.
Can't create/write to file 'C:\Windows\TEMP\#sql_490_0.MYD' (Errcode: 17)
can you please help me?
我使用过Joomla 2.5，管理员模块管理器显示此类错误。 p>
无法创建/写入文件'C：\ Windows \ TEMP \ #sql_490_0.MYD'（错误代码：17）
code> pre>
可以 你能帮帮我吗？ p>
div>
答
See http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html
There are several reasons for this Error:
- No disk space left
- Antivirus or Microsoft Security Essential blocks the file
- Running two instances of MySQL which are trying to write the same file
- 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