public inbox for gentoo-user@lists.gentoo.org
 help / color / mirror / Atom feed
From: Daniel Frey <djqfrey@gmail.com>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] [slightly O/T] mysql problems
Date: Tue, 14 Oct 2014 12:21:27 -0700	[thread overview]
Message-ID: <543D77B7.7010707@gmail.com> (raw)
In-Reply-To: <201410141955.04196.michaelkintzios@gmail.com>

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


  reply	other threads:[~2014-10-14 19:21 UTC|newest]

Thread overview: 11+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2014-10-14 18:54 [gentoo-user] [slightly O/T] mysql problems Mick
2014-10-14 19:21 ` Daniel Frey [this message]
2014-10-14 21:39   ` Mick
2014-10-14 20:15 ` Kerin Millar
2014-10-14 22:25   ` Mick
2014-10-15  1:14     ` Kerin Millar
2014-10-15 12:05       ` Mick
2014-10-15 12:41         ` Kerin Millar
2014-10-15 20:40           ` Mick
2014-10-16  6:24             ` J. Roeleveld
2014-10-17 23:17               ` Mick

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=543D77B7.7010707@gmail.com \
    --to=djqfrey@gmail.com \
    --cc=gentoo-user@lists.gentoo.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox