Hi everyone, Could you let me know if there is a way to enable CSV storage engine after MySQL was built. Below is my current configuration and output of "show engines" mysql> show engines; +------------+---------+------------------------------------------------ ------------+ | Engine | Support | Comment | +------------+---------+------------------------------------------------ ------------+ | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | | HEAP | YES | Alias for MEMORY | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | | MERGE | YES | Collection of identical MyISAM tables | | MRG_MYISAM | YES | Alias for MERGE | | ISAM | NO | Obsolete storage engine, now replaced by MyISAM | | MRG_ISAM | NO | Obsolete storage engine, now replaced by MERGE | | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | | INNOBASE | YES | Alias for INNODB | | BDB | NO | Supports transactions and page-level locking | | BERKELEYDB | NO | Alias for BDB | | NDBCLUSTER | NO | Clustered, fault-tolerant, memory-based tables | | NDB | NO | Alias for NDBCLUSTER | | EXAMPLE | NO | Example storage engine | | ARCHIVE | YES | Archive storage engine | | CSV | NO | CSV storage engine | +------------+---------+------------------------------------------------ ------------+ 16 rows in set (0.00 sec) mysql> status -------------- mysql Ver 14.7 Distrib 4.1.10a, for sun-solaris2.9 (sparc) Connection id: 89977 Current database: Current user: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 4.1.10a-standard-log Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 1 day 19 hours 3 min 14 sec Threads: 5 Questions: 8858515 Slow queries: 467 Opens: 5574 Flush tables: 1 Open tables: 411 Queries per second avg: 57.154 -------------- mysql>
Thank you Mikhail Berman