Even before looking into compiling check if you have CSV enabled already
using :
mysql> show engines;
+------------+---------+----------------------------------------------------------------+
| Engine | Support |
Comment |
+------------+---------+----------------------------------------------------------------+
| MyISAM | YES | Default engine as of MySQL 3.23 with great
performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary
tables |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and
foreign keys |
| BerkeleyDB | NO | Supports transactions and page-level
locking |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it
disappears) |
| EXAMPLE | YES | Example storage
engine |
| ARCHIVE | YES | Archive storage
engine |
| CSV | YES | CSV storage
engine |
| ndbcluster | NO | Clustered, fault-tolerant, memory-based
tables |
| FEDERATED | YES | Federated MySQL storage
engine |
| MRG_MYISAM | YES | Collection of identical MyISAM
tables |
| ISAM | NO | Obsolete storage
engine |
+------------+---------+----------------------------------------------------------------+
12 rows in set (0.00 sec)
If not then you might have to compile the mysql server with the
–with-*csv*-storage-engine
from the source.
On Mon, May 26, 2008 at 3:41 PM, Ananda Kumar <anandkl@stripped> wrote:
> Hi Alex,
> How do i get a csv engine into mysql binaries. Also the file is not comma
> seperate values files, the value is seperated by a different a different
> value.
>
> regards
> anandkl
>
>
> On 5/26/08, Alex Arul Lurthu <alexj@stripped> wrote:
> >
> > On Mon, May 26, 2008 at 2:40 PM, chandru <pradeep.chandru@stripped>
> > wrote:
> >
> >> Hi anand,
> >> To add to alex's views, I see that you do two major operations
> >> 1. Insert
> >>
> >> * Use a temporary table that loads the data initially and then you
> >> copy the same to the original table, which can prevent load on the
> >> original table and shall be faster as well.
> >>
> >
> > Its a good point that Chandru is making here. One more optimization to go
> > with this is the following :
> >
> > If you have csv engine compiled into your binaries, then the temporary
> > table can created just by preparing the file with comma separated values
> and
> > moving the file to data directory and then start the load from there.
> >
> >
> > --
> > Thanks
> > Alex
> > http://alexlurthu.wordpress.com
> >
>
--
Thanks
Alex
http://alexlurthu.wordpress.com
