471,320 Members | 1,729 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,320 software developers and data experts.

needing a script to dump pdf files into a MySQL database

I have a MySQL database and would like to upload multiple pdf files at once and store the information into the db. Here is the db I created:
Expand|Select|Wrap|Line Numbers
  1. 1.    CREATE TABLE `file` ( 
  2. 2.        `id`        Int Unsigned Not Null Auto_Increment, 
  3. 3.        `name`      VarChar(255) Not Null Default 'Untitled.txt', 
  4. 4.        `mime`      VarChar(50) Not Null Default 'text/plain', 
  5. 5.        `size`      BigInt Unsigned Not Null Default 0, 
  6. 6.        `data`      MediumBlob Not Null, 
  7. 7.        `created`   DateTime Not Null, 
  8. 8.        PRIMARY KEY (`id`) 
  9. 9.    ) 
Is there a script that I can run that will accomplish this? I have created a webpage but can only upload one at a time and would just like to do a full dump of 3000 files at once creating a record for each in the db.
Apr 22 '10 #1
1 1676
5,058 Expert 4TB

A browser can not do this for you. It only allows single point-and-click uploads. (Meaning: the user has to select each file manually.) This is for obvious security reasons.

I see three ways to accomplish what you are trying to do:
  1. Upload all the files manually to the server, using FTP or something like that. Then create a server-side script that scans the upload directory and inserts each file it finds.
  2. Create a client-side application (Java, C#, C++, whatever) that acts as a browser, sending each file to the web-application via a HTTP request. - This is of course a lot of work if you only intend to use it once, but it may be a good idea if you intend to do this a lot.
  3. Set the "client" computer (read: your computer) up as a FTP or SSH server, and create a server side script that connects to your computer, downloads the files, and inserts them into the database.

Any way you choose, you will have to custom make the script to fit your specific situation. There is not ready-made script that you can use. (None that I know of, at least. Perhaps on Google, who knows.)
Apr 23 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Sticks | last post: by
3 posts views Thread by somaBoy MX | last post: by
6 posts views Thread by Eric Robinson | last post: by
1 post views Thread by Brian Sadler | last post: by
5 posts views Thread by news | last post: by
4 posts views Thread by Robert Blackwell | last post: by
6 posts views Thread by ssharpjr | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.