From owner-freebsd-database@FreeBSD.ORG Thu Nov 17 15:57:29 2011 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3558E106566C for ; Thu, 17 Nov 2011 15:57:29 +0000 (UTC) (envelope-from list@sprymed.com) Received: from mail-bw0-f54.google.com (mail-bw0-f54.google.com [209.85.214.54]) by mx1.freebsd.org (Postfix) with ESMTP id C05148FC12 for ; Thu, 17 Nov 2011 15:57:28 +0000 (UTC) Received: by bkbzs8 with SMTP id zs8so2941168bkb.13 for ; Thu, 17 Nov 2011 07:57:27 -0800 (PST) MIME-Version: 1.0 Received: by 10.205.128.15 with SMTP id hc15mr25986515bkc.110.1321544021943; Thu, 17 Nov 2011 07:33:41 -0800 (PST) Received: by 10.205.113.196 with HTTP; Thu, 17 Nov 2011 07:33:41 -0800 (PST) Date: Thu, 17 Nov 2011 10:33:41 -0500 Message-ID: From: "list, mailing" To: freebsd-database@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: MySQl 55 server with archive engine X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 17 Nov 2011 15:57:29 -0000 I'm trying to convert a table from InnoDB to Archive: Warning: Unknown storage engine 'Archive' mysql> SHOW ENGINES\G; *************************** 1. row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 2. row *************************** Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance Schema Transactions: NO XA: NO Savepoints: NO *************************** 3. row *************************** Engine: MRG_MYISAM Support: YES Comment: Collection of identical MyISAM tables Transactions: NO XA: NO Savepoints: NO *************************** 4. row *************************** Engine: CSV Support: YES Comment: CSV storage engine Transactions: NO XA: NO Savepoints: NO *************************** 5. row *************************** Engine: MyISAM Support: YES Comment: MyISAM storage engine Transactions: NO XA: NO Savepoints: NO *************************** 6. row *************************** Engine: MEMORY Support: YES Comment: Hash based, stored in memory, useful for temporary tables Transactions: NO XA: NO Savepoints: NO 6 rows in set (0.00 sec) I have searched the ports and cant find the engine archive. also mysql55-server (make config) Options: - OpenSSL and FASTMTX How do I install the engine?? Thanks -- Ben Adams http://www.SpryMed.com/