'File' data type in MySQL??

2005-04-05 Thread preeth k
Hello,
   I am doing packet capturing and I want to store the packet headers and 
payload in a MySQL database. I have decided the datatypes for all the fields 
except for the packet payload. I want to know if I can store the  payload 
particulars in a file and then point that file to the table field. Does MySQL 
support these types of operations? Please suggest a method.
Thanks in advance.
Preeth.

Re: 'File' data type in MySQL??

2005-04-05 Thread Brent Baisley
Not sure what you are asking. MySQL can store actual files in a blob 
field, but it sounds like you only want to store a reference to a file. 
The only way to store a reference to a file is to store it's path name. 
If you want to store the file on a different machine, you would need to 
store more than just path information (i.e. login name and password, 
etc.).
There are strong arguments for storing files in the database or leaving 
them external.

On Apr 5, 2005, at 3:01 AM, preeth k wrote:
Hello,
   I am doing packet capturing and I want to store the packet headers 
and payload in a MySQL database. I have decided the datatypes for all 
the fields except for the packet payload. I want to know if I can 
store the  payload particulars in a file and then point that file to 
the table field. Does MySQL support these types of operations? Please 
suggest a method.
Thanks in advance.
Preeth.
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search  Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]