From: Reindl Harald Date: November 1 2012 1:21am Subject: Re: Dumping drupal databases List-Archive: http://lists.mysql.com/mysql/228558 Message-Id: <5091CEA8.2020803@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig0F7DCEA4AD7D58B21EFF7B9B" --------------enig0F7DCEA4AD7D58B21EFF7B9B Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 01.11.2012 01:54, schrieb Tim Johnson: > * Reindl Harald [121031 08:12]: >> you MUST NOT use "localhost" if you want to connect to >> a different mysqld-port because "localhost" is unix-socket >> >> mysql -h 127.0.0.1 --port=3D3307 -u -p > I get "access denied" when I do that.=20 > thanks don't get me wrong - but do you have any clue about what you are doing? replace with the username drupal is using enter the password drupal is using you got MANY options in thsi thread * let point your default mysqld-datadir to the one the drupal setup used and export the data, after that restore /etc/my.cnf as it is now * stop ANY mysqld instance and copy the db-folder to your used instance * connect to the instance as asid with 127.0.0.1 if you are not able or/and willing to do any of these 3 options i am really out of hope that you should do whatever you believe is your job by missing basic understanding --------------enig0F7DCEA4AD7D58B21EFF7B9B 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://www.enigmail.net/ iEYEARECAAYFAlCRzqgACgkQhmBjz394AnmPEgCeLcFEjrcTd6nW2+73VfLqGpjA bFEAn0btbju2Umpoo6F0wGKDcWmEdK8B =tQzc -----END PGP SIGNATURE----- --------------enig0F7DCEA4AD7D58B21EFF7B9B--