Jump to content
The Uniform Server Community

Search the Community

Showing results for tags 'load_file'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General Forum
    • Announcements
    • Developer
  • Support
    • Uniform Server - Windows
    • Plug-Ins Support
    • Programming & Web Design
    • Trackers
  • Community
    • Open Discussion
    • Off-Topic

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


SourceForge ID


Wiki ID


IRC Nickname

Found 1 result

  1. I'm trying to create a database of articles and in order to test it I wanted to make a test database from the command line and insert a row in it. But one column is supposed to hold a pdf file in a longblob, and load_file always returns NULL Both trying this as an insert and as a test select is failing. I tried granting all privileges to root@localhost, hoping that would fix it, but it didn't help. I tried setting max_allowed_packet = 50M but that didn't help. Here is the sample table I tried, and the insert command: CREATE TABLE articles (article_id int not null AUTO_INCREMENT, article_title varchar(1000) not null, article_pdf longblob not null, PRIMARY KEY (article_id), FULLTEXT(article_title)); insert into articles (article_title, article_pdf) values ('Route of hydrodynamic turbulence in rotating shear flow: Secondary perturbation triggers growing eigenmodes through the elliptical instability',load_file('C:\Users\user\Documents\sample_papers\0509001.pdf')); That always fails with article_pdf can't be NULL. It also fails as load_file('C:\\Users\\user\\Documents\\sample_papers\\0509001.pdf') and as load_file('C:/Users/user/Documents/sample_papers/0509001.pdf') Similarly if I test as simply Select load_file('C:/Users/user/Documents/sample_papers/0509001.pdf'); it returns NULL I tried dropping a simple text file everywhere I could think of, and testing with Select load_file('testfile.txt'); always returns NULL too. Help! How can I upload a blob from the command line using Uniform Server's mysql command line? And if that doesn't work, can I do it from php?
×
×
  • Create New...