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 9C1D61387CA for ; 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 ; Wed, 15 Oct 2014 20:41:28 +0000 (UTC) Received: by mail-wi0-f178.google.com with SMTP id h11so3302211wiw.11 for ; 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 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Wed, 15 Oct 2014 13:41:25 -0700 (PDT) From: Mick 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: 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 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 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--