From mboxrd@z Thu Jan 1 00:00:00 1970
Return-Path: <gentoo-user+bounces-159331-garchives=archives.gentoo.org@lists.gentoo.org>
Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80])
by finch.gentoo.org (Postfix) with ESMTP id 9C1D61387CA
for <garchives@archives.gentoo.org>; Wed, 15 Oct 2014 20:41:38 +0000 (UTC)
Received: from pigeon.gentoo.org (localhost [127.0.0.1])
by pigeon.gentoo.org (Postfix) with SMTP id 7CDD8E096F;
Wed, 15 Oct 2014 20:41:29 +0000 (UTC)
Received: from mail-wi0-f178.google.com (mail-wi0-f178.google.com [209.85.212.178])
(using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits))
(No client certificate requested)
by pigeon.gentoo.org (Postfix) with ESMTPS id 518D8E0918
for <gentoo-user@lists.gentoo.org>; Wed, 15 Oct 2014 20:41:28 +0000 (UTC)
Received: by mail-wi0-f178.google.com with SMTP id h11so3302211wiw.11
for <gentoo-user@lists.gentoo.org>; Wed, 15 Oct 2014 13:41:26 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=20120113;
h=from:reply-to:to:subject:date:user-agent:references:in-reply-to
:mime-version:content-type:content-transfer-encoding:message-id;
bh=MiGb0BW7XDVOtxCtmURlcbMRlU4+hUDNACviqIoKMyM=;
b=UocqqWCc4NLu6n6ZGRBSn9YFCLd5ViRkqIWPiho3Zm4eVCExgOytUGWJX8xARy2W14
ldFFL7hsFoKLo46Ai0bp9lWSIUotTXnnNnKbw6mzIeT6Ol1vRU9b3McMINhIZcy856Rb
/5Gmti+3crLkhvPFvjk/qFOJfLI8fvrUCnsCwUqPL6oAuuXpBm+VtxIvPEGYmynn41Ai
uSuWG67Z4ruMIS0YhGDQ7gK1ECSU9Vl5kjh0lOIGCQwFUzKA6gnjrmN3gc+ak3bIx9AN
xfkrYea+Iv+rxOcXDtRLilH0DaYR84qLW0bL/wMw0x7dhBW999TLNaKGnzOXmTrv8U3m
wpLg==
X-Received: by 10.180.85.197 with SMTP id j5mr14611226wiz.51.1413405686907;
Wed, 15 Oct 2014 13:41:26 -0700 (PDT)
Received: from dell_xps.localnet (230.3.169.217.in-addr.arpa. [217.169.3.230])
by mx.google.com with ESMTPSA id fx10sm20574537wib.12.2014.10.15.13.41.25
for <gentoo-user@lists.gentoo.org>
(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
Wed, 15 Oct 2014 13:41:25 -0700 (PDT)
From: Mick <michaelkintzios@gmail.com>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] [slightly O/T] mysql problems
Date: Wed, 15 Oct 2014 21:40:56 +0100
User-Agent: KMail/1.13.7 (Linux/3.14.14-gentoo; KDE/4.12.5; x86_64; ; )
References: <201410141955.04196.michaelkintzios@gmail.com> <201410151305.18439.michaelkintzios@gmail.com> <543E6B5F.8050900@fastmail.co.uk>
In-Reply-To: <543E6B5F.8050900@fastmail.co.uk>
Precedence: bulk
List-Post: <mailto:gentoo-user@lists.gentoo.org>
List-Help: <mailto:gentoo-user+help@lists.gentoo.org>
List-Unsubscribe: <mailto:gentoo-user+unsubscribe@lists.gentoo.org>
List-Subscribe: <mailto:gentoo-user+subscribe@lists.gentoo.org>
List-Id: Gentoo Linux mail <gentoo-user.gentoo.org>
X-BeenThere: gentoo-user@lists.gentoo.org
Reply-to: gentoo-user@lists.gentoo.org
MIME-Version: 1.0
Content-Type: multipart/signed;
boundary="nextPart2444574.cKvOFByCMp";
protocol="application/pgp-signature";
micalg=pgp-sha256
Content-Transfer-Encoding: 7bit
Message-Id: <201410152141.06240.michaelkintzios@gmail.com>
X-Archives-Salt: f03720c2-e59d-444c-b74b-2d4834076a7f
X-Archives-Hash: e399c8051f6018f38293238772133616
--nextPart2444574.cKvOFByCMp
Content-Type: Text/Plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
On Wednesday 15 Oct 2014 13:41:03 Kerin Millar wrote:
> > Database changed
> > mysql> DROP TABLE `website1@002dnew`.`actions`;
>=20
> Is this a table for which it is also complaining that a corresponding=20
> tablespace doesn't exist in database `website1@@002dnew`? Your original=20
> post mentioned only a table named `webform_validation_rule_components`.
Yes, there are loads of tables that it is complaining about. However, the=
=20
name of the database mentioned in the logs is not that of the local machine=
,=20
but of the remote.
> Whichever table(s) it is complaining about, if you happen to find a=20
> corresponding .idb file in a different database (sub-directory), you=20
> might be able to satisfy MySQL by copying it to where it is expecting to=
=20
> find it. If that works, you should then be able to drop it.
I lost you here. We have the local database, website_test. In it I can se=
e a=20
number of tables. I also have other databases for different websites. Whe=
re=20
am I supposed to look for corresponding .idb files?
> Sometimes, directly copying an InnoDB tablespace into place requires a=20
> more elaborate procedure but I won't muddy the waters by describing said=
=20
> procedure just yet.
>=20
> > ERROR 1051 (42S02): Unknown table 'actions'
> > mysql> DISCARD TABLESPACE `website1@002dnew`.`actions`;
> > ERROR 1064 (42000): You have an error in your SQL syntax; check the
> > manual that corresponds to your MySQL server version for the right
> > syntax to use near 'DISCARD TABLESPACE `website1@002dnew`.`actions`' at
> > line 1
> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
> >=20
> > I think in mysql-5.5 I should be using DROP TABLESPACE instead?
>=20
> My mistake. The correct syntax for discarding the tablespace would be:
>=20
> ALTER TABLE <table> DISCARD TABLESPACE;
>=20
> I'm stating the obvious here, but be sure not to DROP or DISCARD=20
> TABLESPACE on a table whose tablespace does exist and for which you do=20
> not have a backup. Both commands are destructive.
Well, I still have the backup from the live website, I can restore from it =
if=20
I have to. However, what I find confusing is that the errors mention the l=
ive=20
website's database name, not the local database. Shouldn't the import=20
function import the tables into the local database?
=2D-=20
Regards,
Mick
--nextPart2444574.cKvOFByCMp
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
iQEcBAABCAAGBQJUPtviAAoJELAdA+zwE4Ye/doIALxFvRvLVfUdcsSY02f4sv2k
V1PHjXdViQr4enU6BpyxLl3hd1knePWxq05ajyqllU74S7Abpt8yxiDNsukCiitq
wAQP2ogHcggWh74xfBtJgEc+TRSX24pHF6peFqBKjfkze61ZWBKMMz6w3BTjndMl
uP/X4r/N3i5ThmlY4yYbdBKLebUq713OEPGqjqkO4XBHgN6uWfklFDfTqLYssohZ
AIskslKGnPKc39iKGPEJ2F/4UHsSUG6IssVaLGSvARsa0U7wLGnaSLzwbBMyUDTx
sQlkIsAlBV2SIpzoOs+3T8CgjlekQ659aI7VGSzI42jNb3MkTw4RXJygVXgeNFU=
=So0D
-----END PGP SIGNATURE-----
--nextPart2444574.cKvOFByCMp--