6 messages in com.mysql.lists.win32Re: has anybody added a file > 16Meg ...| From | Sent On | Attachments |
|---|---|---|
| Mark Mchugh | 19 Apr 2005 08:52 | |
| Berman, Mikhail | 19 Apr 2005 13:50 | |
| Petr Vileta | 19 Apr 2005 18:42 | |
| Mark Mchugh | 20 Apr 2005 01:54 | |
| Mark Mchugh | 20 Apr 2005 01:55 | |
| Petr Vileta | 20 Apr 2005 14:07 |
| Subject: | Re: has anybody added a file > 16Meg to mysql? |
|---|---|
| From: | Petr Vileta (pe...@practisoft.cz) |
| Date: | 04/20/2005 02:07:34 PM |
| List: | com.mysql.lists.win32 |
Yes, you can use directory on any PC where MySQL is running :-) I have webserver too (Linux, Apache, MySQL, Perl) and I'm storing uploaded files into database too, but not whole file to table. I store file special to server directory (eg. /var/www/any_domain/upload) and into table I store the pathname and filename only. If I can to sumarise "all files uploaded between 1-31 January" the mysql result is very quickly. My web pages are generated by Perl and into mysql tables and directories write Perl too. Realy, putting Megs of files into table is a not good idea ;-)
Petr Vileta, Czech republic (My server reject all messages from Yahoo and Hotmail. Send me your mail from another non-spammer site please.)
----- Original Message ----- From: "Mark Mchugh" <mark...@yahoo.com> To: "Petr Vileta" <pe...@practisoft.cz>; "mysql list" <win...@lists.mysql.com> Sent: Wednesday, April 20, 2005 10:54 AM Subject: Re: has anybody added a file > 16Meg to mysql?
Thanks for this, but its not ideal for me as i want to store the files on a webserver and not on a local network....
MArk --- Petr Vileta <pe...@practisoft.cz> wrote:
This is a not good idea to store X Meg files into table. Store file into some directory and into mysql table put the path only. It's work fine and very quickly.
Petr Vileta, Czech republic (My server reject all messages from Yahoo and Hotmail. Send me your mail from another non-spammer site please.)
----- Original Message ----- From: "Mark Mchugh" <mark...@yahoo.com> To: "mysql list" <win...@lists.mysql.com> Sent: Tuesday, April 19, 2005 5:52 PM Subject: has anybody added a file > 16Meg to mysql?
i cant seem to get anything over 16 Meg into a table?
__________________________________ Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! http://travel.yahoo.com/p-travelguide
-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe:
http://lists.mysql.com/win32?unsub=pe...@practisoft.cz
-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe:
http://lists.mysql.com/win32?unsub=mark...@yahoo.com
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=pe...@practisoft.cz