Re: How To run Multiple Storage Engines: CSV, InnoDB...

[Colin Charles <colin@xxxxxxxxx>]

Robert L Cochran wrote:

Hi!

<snipped>
> | CSV        | NO      | CSV storage
> engine                                             |

This is the problem... it should say:
| CSV        | YES      | CSV storage engine 
                 |

> I'm not sure if a 'YES' in the 'Support' column above means the engine
> is started at runtime, or if it means the MySQL server was compiled with
> support for that engine. In any case, I want to be able to use the CSV
> engine in addition to MyISAM, MEMORY, InnoDB, BerkeleyDB and MRG_MYISAM.
> How do I "activate" that CSV engine?

For the CSV engine to be able to be used, you should rebuild the package 
to allow the CSV engine

You could also file a bug with CentOS to ask for it to be enabled by default

Or download it from dev.mysql.com/downloads/ - mysql 5.0.51a from there 
has all engines enabled, except ndbcluster, isam, and berkeleydb (12 
rows are returned with show engines;)

hope this helps!


--
Colin Charles, Community Relations Manager, APAC
Database Group, Sun Microsystems Inc., http://www.mysql.com/
Tel: +6012 204 3201 (Malaysia) | colincharles (Skype)
Web: http://www.bytebot.net/blog/

MySQL Forge: http://forge.mysql.com/


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx