From mboxrd@z Thu Jan 1 00:00:00 1970
Return-Path: <gentoo-user+bounces-159352-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 53AB71387D2
for <garchives@archives.gentoo.org>; Fri, 17 Oct 2014 23:18:01 +0000 (UTC)
Received: from pigeon.gentoo.org (localhost [127.0.0.1])
by pigeon.gentoo.org (Postfix) with SMTP id 4EC11E08FC;
Fri, 17 Oct 2014 23:17:56 +0000 (UTC)
Received: from mail-wg0-f41.google.com (mail-wg0-f41.google.com [74.125.82.41])
(using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits))
(No client certificate requested)
by pigeon.gentoo.org (Postfix) with ESMTPS id E755FE08A5
for <gentoo-user@lists.gentoo.org>; Fri, 17 Oct 2014 23:17:54 +0000 (UTC)
Received: by mail-wg0-f41.google.com with SMTP id b13so1859929wgh.0
for <gentoo-user@lists.gentoo.org>; Fri, 17 Oct 2014 16:17:53 -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=LVm8pwTxipeFys+1E1yPj9nNWcUH3hRAaWU1lh2Agx4=;
b=FV6Lk4uLxIfL6C8qL8g8AsRxHlfpCuW3JXa+bs0KJ+9iQVtbU7OZYshyex97pWzoGt
noaxRT4/4Ky67AaqpvMjMw6vuuR00lLdeUS/OgZY+PETBLxrmxzqOcnZiz0MCkHaFK1d
xd129mPt5jFj10XC/7azpnkfOaWAyPAVjvmCtd+qA8z0DR444orR79+Sw9V1Sq2EmCQl
4kGzfK8sT//AY8SS3dvu9GAsa4FY12Gy8tX6pyWS40y8v5zOuAtp582qkCEUJFggazmk
YsogMeZ+btzP2MdGJ3fdQWFSgcTJ69vDdJgm7zepUcHnXUqn1/P78O5io1mrY1AS6MfQ
emzg==
X-Received: by 10.194.93.194 with SMTP id cw2mr1626773wjb.112.1413587873482;
Fri, 17 Oct 2014 16:17:53 -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 ws2sm3289948wjc.32.2014.10.17.16.17.51
for <gentoo-user@lists.gentoo.org>
(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
Fri, 17 Oct 2014 16:17:52 -0700 (PDT)
From: Mick <michaelkintzios@gmail.com>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] [slightly O/T] mysql problems
Date: Sat, 18 Oct 2014 00:17:04 +0100
User-Agent: KMail/1.13.7 (Linux/3.14.14-gentoo; KDE/4.12.5; x86_64; ; )
References: <201410141955.04196.michaelkintzios@gmail.com> <201410152141.06240.michaelkintzios@gmail.com> <6256627.JaWHi3O9FL@andromeda>
In-Reply-To: <6256627.JaWHi3O9FL@andromeda>
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="nextPart3131022.RvjeKuU9Ql";
protocol="application/pgp-signature";
micalg=pgp-sha256
Content-Transfer-Encoding: 7bit
Message-Id: <201410180017.31318.michaelkintzios@gmail.com>
X-Archives-Salt: 3f27bcac-350b-4d11-9fad-ef8446b5e818
X-Archives-Hash: 09978f16d76a5ed7479430eb932dba7f
--nextPart3131022.RvjeKuU9Ql
Content-Type: Text/Plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
On Thursday 16 Oct 2014 07:24:43 J. Roeleveld wrote:
> On Wednesday, October 15, 2014 09:40:56 PM Mick wrote:
> > Well, I still have the backup from the live website, I can restore from
> > it if I have to. However, what I find confusing is that the errors
> > mention the live website's database name, not the local database.=20
> > Shouldn't the import function import the tables into the local database?
>=20
> When you do it as you said:
> mysql -u webadmin -h localhost -p website_test < website1_20141014.sql
>=20
> then that is the expected result (that it uses tables in the local
> database.)
>=20
> Can you do a search in the SQL-file for references to the remote database
> and post some of those lines? (Preferably only a subset referencing a
> single table)
Thank you both for your help. I think I have fixed whatever it was that ha=
d=20
gone sideways, but I can't explain it with any certainty.
So, here is what happened. The local database name more than a year ago ha=
d a=20
hyphen in the name; e.g. "website-new". When listing /var/lib/mysql it was=
=20
shown as: website@002dnew
However, 9 months ago I had dropped that database and created a new databas=
e=20
with an underscore instead of a hyphen; e.g. website_new. Imported the tab=
les=20
from the remote database into it and carried on with my work.
Suddenly, I notice all these errors in the log. They were definitely not=20
there before and in any case the website-new directory was no longer listed=
in=20
/var/lib/mysql, while website_new was there.
I dropped website_new, recreated website-new and the errors in the logs=20
stopped. Finally, I dropped website-new again, recreated website_new and=20
still no errors in the logs. :-)
The only problem is that now I can't load the website from the recreated=20
website_new database! LOL! I will look at it later, but wanted to report=
=20
that the errors I posted about have thankfully gone. I blame it all on=20
filesystem corruption of some sort (ext4), as it was running out of space, =
but=20
can't be sure.
Thanks again.
=2D-=20
Regards,
Mick
--nextPart3131022.RvjeKuU9Ql
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
iQEcBAABCAAGBQJUQaOLAAoJELAdA+zwE4YeohwIAIv1xdvya0q406gZ5gE+X7yk
dpM2urBf4oJHJZj0PHr4fzF63Ic/U7INYw1NrxiNoZcqpokzTgY5R8OdFoTrpIDM
Mq+ghqtGjlVz9/2oZiiWsDXE4xo0nYXJeE9YaMZgWrl0sOOcnQN06JJRMpfXSaeP
Es5SWYM0wTXCklFpOrhurEFVxslfoJbIDhcU4WY4bUWVT8rHRJ50x+ocG+SmHOj3
/sXh1LKQK2YU1vdvihZUxR4Qpr3GyK7d3gN3fOFLHr9vw93lRS1VVbydTM4G6bHN
8aNCRTj5TK1qtep5Bfu5OGy2Uc1S/fy+E5uxzBWK7sUwvme7Q7f2ZZuQ79Czdew=
=Vr09
-----END PGP SIGNATURE-----
--nextPart3131022.RvjeKuU9Ql--