Results 1 to 2 of 2

Thread: MySql Load_File on Windows.

  1. #1
    Senior Member
    Join Date
    Sep 2007
    Posts
    409
    Thanks
    7
    Thanked
    32 times in 12 posts
    • icanhazburger's system
      • Motherboard:
      • Foxconn 946GZ7MA/946PL7MA Series
      • CPU:
      • DualCore Intel Core 2 Duo E6400
      • Memory:
      • 2 gig DDR2-667
      • Storage:
      • 320gig Baracuda II
      • Graphics card(s):
      • 7900 GS vc3600 cooler
      • PSU:
      • 600w
      • Case:
      • Something with a 25cm fan
      • Monitor(s):
      • 1 x 22"w 1 x 19"
      • Internet:
      • Pipex Max :(

    MySql Load_File on Windows.

    Hi all, I'm using Load_File to insert the contents of .doc files into a MySql database running on Windows Server 2003.

    For some reason it only seems to work if the file is in the root of the drive and not in a folder -

    LOAD_FILE('d:\ALEXANDER Richard.doc') works

    LOAD_FILE('d:\wr\data\ALEXANDER Richard.doc') does not work, it just returns NULL.

    The file does exist in both cases.

    The MySql service is set to logon as the Local System Account.

    I'm guessing its something to do with permissions, but other than that I'm lost.

    edit : Seems I solved my own problem -

    LOAD_FILE('d:/wr/data/ALEXANDER Richard.doc') does work.
    Last edited by icanhazburger; 08-12-2008 at 02:33 PM. Reason: Sorted
    In the internets, no one can hear you sarcasm.

  2. #2
    Comfortably Numb directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,027 times in 678 posts
    • directhex's system
      • Motherboard:
      • Asus ROG Strix B550-I Gaming
      • CPU:
      • Ryzen 5900x
      • Memory:
      • 64GB G.Skill Trident Z RGB
      • Storage:
      • 2TB Seagate Firecuda 520
      • Graphics card(s):
      • EVGA GeForce RTX 3080 XC3 Ultra
      • PSU:
      • EVGA SuperNOVA 850W G3
      • Case:
      • NZXT H210i
      • Operating System:
      • Ubuntu 20.04, Windows 10
      • Monitor(s):
      • LG 34GN850
      • Internet:
      • FIOS

    Re: MySql Load_File on Windows.

    backslash is used in pretty much every programming language as a special character

    "\n" means "new line", for example. "\t" for tab.

    "\\" is the code for an actual backslash. use that

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Looking Through Windows
    By Paul Adams in forum Software
    Replies: 16
    Last Post: 19-10-2018, 09:07 AM
  2. TV Tuner, Windows Media Centre and Windows Vista Home Premium.
    By oimi in forum Help! Quick Relief From Tech Headaches
    Replies: 5
    Last Post: 17-11-2008, 05:16 PM
  3. FYI: No Service Pack 5 for Windows 2000
    By Paul Adams in forum Software
    Replies: 7
    Last Post: 01-12-2004, 03:03 PM
  4. Windows Installation Fatal Error
    By Weng in forum Software
    Replies: 23
    Last Post: 16-10-2004, 02:57 PM
  5. Windows XP Email?
    By joshwa in forum Software
    Replies: 9
    Last Post: 18-01-2004, 09:38 AM

Posting Permissions

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