Re: CSV Output

[Japheth Cleaver]

At 11:07 AM 8/12/2004, David Perron wrote:
Im looking for a way to output a file into true CSV format (with quoted
fields) using the Perl DBI.
Does anyone know of a way to do this (in either native MySQL or Perl)?
Thanks as always!

You could try DBD::CSV http://search.cpan.org/search?query=DBD%3A%3ACSV
It calls itself alpha software, but states that that's due to the interface 
possibly changing, not the code quality. YMMV.

-jc 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Upgrading mySQL 3.23 to 4.0

[Japheth Cleaver]

At 01:58 PM 8/2/2004, [EMAIL PROTECTED] wrote:
Greetings:
 I am trying to upgrade to the new version of mySQL on Fedora Core 2 
Linux.  I have "mysql  Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)"

I downloaded the following files:
 MySQL-client-4.0.20-0.i386.rpm
 MySQL-server-4.0.20-0.i386.rpm
and as root ran the following:
[EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-server-4.0.20-0.i386.rpm 
MySQL-client-4.0.20-0.i386.rpm
warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 
5072e1f5
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-4
libmysqlclient.so.10 is needed by (installed) 
mod_auth_mysql-20030510-4.1
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.4-11
[EMAIL PROTECTED] Desktop]#

I am not sure what I need to do can someone please assist.
Thank You
Gary

Install
- MySQL-shared-4.0.20-0.i386.rpm, and
- MySQL-shared-compat-4.0.20-0.i386.rpm as well.
And probably MySQL-devel-4.0.20-0.i386.rpm just for kicks.
The 2nd one is the specific package that should solve the problem, 
especially with the php-mysql package.

HTH,
Japheth "J.C." Cleaver
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL as document storage?

[Japheth Cleaver]

One solution might be concurrant storage of different versions of the same 
file in different blobs. Text-based formats (SGML, rtf, HTML, XHTML, plain 
text) can be stored in TEXT columns, while Binary formats (PDF?, GIF/PNG, 
Media) can be stored in BLOBs.

A nice side effect of this is being able to allow the choice of different 
requested formats of the same file easily; but the key benefit is the 
ability to simply index the plain text column of everything and do your 
searches by that.

Regards,

Japheth "J.C." Cleaver
[EMAIL PROTECTED]
At 12:56 PM 1/7/2004, Steve Folly wrote:
Hi,

(disclaimer - this thread could easily go off topic; I'm interested only 
in the MySQL aspects of what follows...)

At work we are currently investigating ways of filing all our electronic 
documents.

There is commercial software that will do this I know, but I was wondering 
whether MySQL would be suitable for this type of thing.

The 'documents' could be literally any binary file. My idea would be to 
create a table with a blob column for the document itself, and document 
title, reference number, keywords, other meta-data. And a web-based 
front-end to search and serve documents.

Although the documents could be any file, the majority would be textual 
documents (Word documents, PDF, etc). How would one go about indexing such 
data, since full text searches operate on textual columns?

How to cope with columns exceeding the max packet length? Why is there a 
max_packet_length setting; surely this is low-level stuff that shouldn't 
affect query and result sizes?

Is storing the actual documents in the database such a good idea anyway? 
Perhaps store the file in a file system somwhere and just store the filename?

If anyone has experience in doing (or been dissuaded from doing) this kind 
of application your thoughts and comments would be appreciated. (If only 
to tell me "don't be so stupid, it'll never work" :)

Thanks.

--
Regards,
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]