Re: 'File' data type in MySQL??

Brent Baisley Tue, 05 Apr 2005 05:24:22 -0700

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]

Re: 'File' data type in MySQL??

Reply via email to