From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id 9B53313838B for ; Tue, 14 Oct 2014 19:21:41 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 17D4CE0884; Tue, 14 Oct 2014 19:21:33 +0000 (UTC) Received: from mail-pa0-f47.google.com (mail-pa0-f47.google.com [209.85.220.47]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id E6021E0870 for ; Tue, 14 Oct 2014 19:21:31 +0000 (UTC) Received: by mail-pa0-f47.google.com with SMTP id rd3so8458060pab.34 for ; Tue, 14 Oct 2014 12:21:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=fRkj/4u1/VGY2VnXifc+OqCHq+1HNyz1RmKiL3mStDY=; b=m1HqiZ8qnmrRQcYhbk9ez3mqp83V+l/TU91Dp5EKkrsMWeTp/XBkB8r9tppZd88Wbw wYCx0fWFOx0He0KoZL7Bl+C6mBKZ2EiJkQVJhx4sva1sufVUPEYxQ8QJwvNqr/t+gr3e sc4l/0UJYIUI23g7vkZc3kY/lUBq0jd5GOTH1enhko+VNFVdUjDhwE8kynl0HnZVoKdv 4oCX7XSiFBTIxzKU2ahqbjTDygHXtqSEbcc1gQvX0/1kmntdMpa/JUEB+iXXyP1nAR8n 2E/WAy6LGtxDmqsTyYbiJIfPn3dUQSPtvoayQAMMpJ/X9fKXJFkhSkQoeED03eMTezkq +PCw== X-Received: by 10.68.129.103 with SMTP id nv7mr7581836pbb.56.1413314490667; Tue, 14 Oct 2014 12:21:30 -0700 (PDT) Received: from [192.168.247.60] (76-10-185-200.dsl.teksavvy.com. [76.10.185.200]) by mx.google.com with ESMTPSA id oq6sm14959464pdb.45.2014.10.14.12.21.29 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 14 Oct 2014 12:21:30 -0700 (PDT) Message-ID: <543D77B7.7010707@gmail.com> Date: Tue, 14 Oct 2014 12:21:27 -0700 From: Daniel Frey User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.7.0 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] [slightly O/T] mysql problems References: <201410141955.04196.michaelkintzios@gmail.com> In-Reply-To: <201410141955.04196.michaelkintzios@gmail.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Archives-Salt: bef46a45-430a-493b-bfb5-5331d1c80bf8 X-Archives-Hash: 2a4903540d03c05167c1d823e08f88fd On 10/14/2014 11:54 AM, Mick wrote: > Hi All, > > This may be slightly off topic, but I thought of asking here first. I noticed > two problems, one specific to a particular database, the other more general. > In reverse order: > > > 1. I am getting this error when I start mysqld > > 141014 19:41:38 [Warning] /usr/sbin/mysqld: unknown option '--loose-federated' Did you compile with the 'extraengine' USE flag? It's required for federated engine support. > 141014 19:41:37 InnoDB: Error: trying to open a table, but could not > InnoDB: open the tablespace file > './website1@002dnew/webform_validation_rule_components.ibd'! > Does this file (and directory) exist? > > Is this some error imported from the live site, or is it due to something > being wrong locally? Most likely the live website stores its files in a different place. I'm not sure how to fix that, though. I would imagine the error text gives hints. (DISCARD TABLESPACE and IMPORT TABLESPACE - I've never used them.) Then again, I only use mysql for pretty basic stuff. Dan