duandou2763 2012-10-25 13:20
浏览 19
已采纳

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?

  • 写回答

1条回答 默认 最新

  • duangao8359 2012-10-25 13:26
    关注

    See http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html

    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

    Other, similar questions on SO, Google.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?