Professional Web Applications Themes

Error 1 : Can't create/write to file - MySQL

I'm really not able to resolve this. I have a SELECT...INTO OUTFILE query If I execute it I receive: Error 1 : Can't create/write to file 'myfile.txt' I've read [url]http://dev.mysql.com/doc/refman/5.0...not-create.html[/url] and so : 1. I've modified " #tmp= /tmp " in " tmp=/tmp/mysql_tmp 2. I've give it permission (mysql) 3. I've modified php safe_mode to off I still receive the same error. Why?? Luca...

  1. #1

    Default Error 1 : Can't create/write to file

    I'm really not able to resolve this.

    I have a SELECT...INTO OUTFILE query

    If I execute it I receive:
    Error 1 : Can't create/write to file 'myfile.txt'

    I've read
    [url]http://dev.mysql.com/doc/refman/5.0...not-create.html[/url]

    and so :
    1. I've modified " #tmp= /tmp " in " tmp=/tmp/mysql_tmp
    2. I've give it permission (mysql)
    3. I've modified php safe_mode to off

    I still receive the same error. Why??

    Luca


    Luca Guest

  2. #2

    Default Re: Error 1 : Can't create/write to file

    Luca wrote:
    > I'm really not able to resolve this.
    >
    > I have a SELECT...INTO OUTFILE query
    >
    > If I execute it I receive:
    > Error 1 : Can't create/write to file 'myfile.txt'
    >
    > I've read
    > [url]http://dev.mysql.com/doc/refman/5.0...not-create.html[/url]
    >
    > and so :
    > 1. I've modified " #tmp= /tmp " in " tmp=/tmp/mysql_tmp
    > 2. I've give it permission (mysql)
    > 3. I've modified php safe_mode to off
    >
    > I still receive the same error. Why??
    >
    > Luca
    >
    >
    Did you take the # away from the front of the line? Otherwise it's a
    comment.

    Do YOU have write permission for /tmp/mysql_tmp?


    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    [email]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

Similar Threads

  1. write/create new file using IIS, XP Pro
    By BB in forum PHP Development
    Replies: 4
    Last Post: February 28th, 05:06 PM
  2. Error when saving as .ai with Create PDF Compatible File checked
    By Joe_McNamara@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 1
    Last Post: May 5th, 06:35 PM
  3. Read/write Excel and create pdf??
    By flashPipe in forum Macromedia Director Basics
    Replies: 0
    Last Post: April 6th, 05:23 PM
  4. Error when trying to create PDF file - Acrobat 6.0
    By Linda_Creed1@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: April 3rd, 09:09 AM
  5. Replies: 1
    Last Post: September 8th, 02:20 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139