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=gcdmw-win32@m.gmane.org

RE: has anybody added a file > 16Meg to mysql?

Mark,

Check this variable

max_allowed_packet | 1047552

With=20

mysql> show variables like "max%";
+----------------------------+----------------------+
| Variable_name | Value |
+----------------------------+----------------------+
| max_allowed_packet | 1047552 |
| max_binlog_cache_size | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 18446744073709551615 |
+----------------------------+----------------------+
17 rows in set (0.00 sec)
=20

-----Original Message-----
From: Mark Mchugh [mailto:mark_mch@yahoo.com]=20
Sent: Tuesday, April 19, 2005 11:53 AM
To: mysql list
Subject: has anybody added a file > 16Meg to mysql?

i cant seem to get anything over 16 Meg into a table?



=09
__________________________________
Do you Yahoo!?=20
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=3Dmberman@ivesinc.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: has anybody added a file > 16Meg to mysql?

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"
To: "mysql list"
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=petr@practisoft.cz
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

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 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"
> To: "mysql list"
> 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=petr@practisoft.cz
> >
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=mark_mch@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=gcdmw-win32@m.gmane.org

RE: has anybody added a file > 16Meg to mysql?

Thanks, but this is ok, i have it set to 80Meg....


has anybody managed to add large files on mysql for
windows?


thanks
--- "Berman, Mikhail" wrote:
> Mark,
>
> Check this variable
>
> max_allowed_packet | 1047552
>
> With
>
> mysql> show variables like "max%";
>
+----------------------------+----------------------+
> | Variable_name | Value
> |
>
+----------------------------+----------------------+
> | max_allowed_packet | 1047552
> |
> | max_binlog_cache_size | 18446744073709551615
> |
> | max_binlog_size | 1073741824
> |
> | max_connect_errors | 10
> |
> | max_connections | 100
> |
> | max_delayed_threads | 20
> |
> | max_error_count | 64
> |
> | max_heap_table_size | 16777216
> |
> | max_insert_delayed_threads | 20
> |
> | max_join_size | 18446744073709551615
> |
> | max_length_for_sort_data | 1024
> |
> | max_relay_log_size | 0
> |
> | max_seeks_for_key | 18446744073709551615
> |
> | max_sort_length | 1024
> |
> | max_tmp_tables | 32
> |
> | max_user_connections | 0
> |
> | max_write_lock_count | 18446744073709551615
> |
>
+----------------------------+----------------------+
> 17 rows in set (0.00 sec)
>
>
> -----Original Message-----
> From: Mark Mchugh [mailto:mark_mch@yahoo.com]
> Sent: Tuesday, April 19, 2005 11:53 AM
> To: mysql list
> 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=mberman@ivesinc.com
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=mark_mch@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=gcdmw-win32@m.gmane.org

Re: has anybody added a file > 16Meg to mysql?

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"
To: "Petr Vileta" ; "mysql list"
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 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"
> > To: "mysql list"
> > 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=petr@practisoft.cz
> > >
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> >
> http://lists.mysql.com/win32?unsub=mark_mch@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=petr@practisoft.cz
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org