From: Reindl Harald
Date: February 27 2012 9:30am
Subject: Re: how to read existing databases copied from somewhere else
List-Archive: http://lists.mysql.com/mysql/226867
Message-Id: <4F4B4D40.6060302@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigD2FCC43E43889C294EE16008"

--------------enigD2FCC43E43889C294EE16008
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 27.02.2012 09:05, schrieb Pengkui Luo:
> Hi, I am new to mysql and have a question regarding how to read/import
> existing mysql databases (i.e. binaries, not sql dumps) copied from
> somewhere.
>=20
> However, the "show databases;" command did not give me the "foo" databa=
se;
> and the "use foo;" command was denied access. Does it have to do with t=
he
> grant table?=20

no, you missed to set the permissions to the datadir
if you copy the whole datadir grant tables are part
of your structure becuase they are defined in the
database "mysql" as also passwords


--------------enigD2FCC43E43889C294EE16008
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk9LTUAACgkQhmBjz394Ank+wQCeM9A7CYADLsLTXg/zTmVAye42
67YAnRg+rAl/29KK6WlZi/CYT1O9K38o
=2fjB
-----END PGP SIGNATURE-----

--------------enigD2FCC43E43889C294EE16008--