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/ From owner-freebsd-database@FreeBSD.ORG Thu Nov 17 16:54:52 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 5F108106566C for ; Thu, 17 Nov 2011 16:54:52 +0000 (UTC) (envelope-from tevans.uk@googlemail.com) Received: from mail-vx0-f182.google.com (mail-vx0-f182.google.com [209.85.220.182]) by mx1.freebsd.org (Postfix) with ESMTP id 1D7958FC0C for ; Thu, 17 Nov 2011 16:54:51 +0000 (UTC) Received: by vcbfy13 with SMTP id fy13so1998710vcb.13 for ; Thu, 17 Nov 2011 08:54:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=sMwfel65nHJovmkgNA8jUkk1UcWFZQYRSJ5QS96aajM=; b=V+/IuWp1yi0jKvglju2Jn207R3yPPhu4plM0HZdsIQGnCWVZN06loUducTBPFF3VSC EusL6f4FKsya1vJ5Gip161qAIsv0DcDOCXsX1nhbT7m5oDlKBeoAZ7TA9aw88sVJLOwR b/VeVrOMvsMmvPUaPh3vYD93dLg/fy6uiHP+c= MIME-Version: 1.0 Received: by 10.52.89.206 with SMTP id bq14mr57394376vdb.39.1321547540931; Thu, 17 Nov 2011 08:32:20 -0800 (PST) Received: by 10.52.182.40 with HTTP; Thu, 17 Nov 2011 08:32:20 -0800 (PST) In-Reply-To: References: Date: Thu, 17 Nov 2011 16:32:20 +0000 Message-ID: From: Tom Evans To: "list, mailing" Content-Type: text/plain; charset=UTF-8 Cc: freebsd-database@freebsd.org Subject: Re: 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 16:54:52 -0000 On Thu, Nov 17, 2011 at 3:33 PM, list, mailing wrote: > I'm trying to convert a table from InnoDB to Archive: > > Warning: Unknown storage engine 'Archive' mysql> install plugin archive soname 'ha_archive.so'; It will then get installed into mysql.plugin table, and loaded every time server starts. Cheers Tom