var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Weird SQL Files Have Filled my TMP Folder
There have been no changes made to any sites on my server for which I can pinpoint to be the cause of this problem...
Basically, I received notice that my TMP folder was full at 100%... so a look into what the heck was taking up all the space reveals several weird .MYI and .MYD files for which I have no idea about.
I cannot open them or view any of their contents. I cannot even edit them.
Does anyone have any information about what these are or why they are in my TMP folder? Any info would help.
Those are index and data files for MySQL Indeed. Reading them with a text editor probably won't help, and these shouldn't be filling your /tmp under normal circumstances.
Is it possible that one of your users/programs is using a
type of query?
SELECT * FROM table INTO OUTFILE '/tmp/xxx';
Check your query logs for the word "outfile" to see if any of your users is up to no good.
Hope this helps.
- hosting software development
How do I check that? (I am not too great with Command line yet).
Any guidance is appreciated. Thanks.
You could grep your code for that query in the command-line:
grep -ir "select * from" /path/to/code | grep -i "into outfile"