Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Location
    Indianapolis
    Posts
    86

    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.

    (Screenshot Attached)

    Click image for larger version. 

Name:	sql_files.JPG 
Views:	108 
Size:	104.3 KB 
ID:	12542

  2. #2
    Join Date
    Aug 2002
    Location
    Canada
    Posts
    665
    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
    SELECT * FROM table INTO OUTFILE '/tmp/xxx';
    type of query?

    Check your query logs for the word "outfile" to see if any of your users is up to no good.

    Hope this helps.
    Alex
    circlical - hosting software development
    forums * blog

  3. #3
    Join Date
    Mar 2006
    Location
    Indianapolis
    Posts
    86
    How do I check that? (I am not too great with Command line yet).

    Any guidance is appreciated. Thanks.

  4. #4
    Join Date
    Jun 2003
    Location
    Janesville, Wi
    Posts
    1,516
    You could grep your code for that query in the command-line:

    grep -ir "select * from" /path/to/code | grep -i "into outfile"
    Jakiao

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •