我如何可以改变sqlite的创建etilqs文件的临时文件夹？ [英] How can I change the temp folder where sqlite creates etilqs files?

问题描述

（这个问题的<一个分拆href=\"http://stackoverflow.com/questions/16121290/how-to-avoid-httpd-exe-from-creating-etilqs-in-c-windows-temp/16121977#16121977\">How为了避免httpd.exe从创建用C \\ WINDOWS \\ TEMP \\？）etilqs

(This question is a spin-off of How to avoid httpd.exe from creating etilqs in C\WINDOWS\TEMP\?)

我的Apache 2.4安装在我的电脑和我用本地主机的Web应用程序。

I have Apache 2.4 installed in my computer and I use a localhost web application.

此应用程序使用SQLite数据库（通过PHP PDO），这是一开始小，但现在它有66518行。

This application uses a sqlite database (through PHP PDO), which was small at the beginning but now it has 66518 rows.

有一段时间，当我运行

SELECT Z.A,B,C,D,(SELECT 1 FROM X WHERE X.A=Z.A AND X.E IS NOT NULL)
FROM Y,Z
Where F=:f AND Y.A=Z.A
ORDER BY D IS NULL DESC, D IS "" ASC, D DESC
LIMIT :startRow,24

在COMODO防火墙的防御+模块警告我说， http.exe 要创建新的文件/文件夹 C：\\ WINDOWS \\ TEMP \\ etilqs_？ ?? ，其中？是随机的数字和字母。

the COMODO Firewall's Defense+ Module warns me that http.exe wants to create the new file/folder C:\WINDOWS\TEMP\etilqs_???, where ??? are random numbers and letters.

我认为，这是因为该数据库已成为大（一开始我没有这个问题）。

I think that it happens because the database has became big (at the beginning I didn't have this problem).

COMODO防火墙给出了警告，因为 C：\\ WINDOWS 是一个受保护的文件夹。然后，也许我可以改变文件夹，以便sqlite的门店在无保护的其中一个文件，以避免该警告。

COMODO Firewall shows the warning because C:\WINDOWS is a protected folder. Then, maybe I could change the folder so that sqlite stores these files in an unprotected one to avoid the warnings.

推荐答案

要更改临时目录中，将 TEMP的值和 TMP 环境变量。

To change the temp directory, change the value of the TEMP and TMP environment variables.

根据您的Windows版本，你很可能会发现他们在计算机➝属性➝高级➝环境变量。

Depending on your Windows version, you are likely to find them under Computer ➝ Properties ➝ Advanced ➝ Environment Variables.

这篇关于我如何可以改变sqlite的创建etilqs文件的临时文件夹？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！