From: Reindl Harald
Date: October 30 2012 4:42pm
Subject: Re: Dumping drupal databases
List-Archive: http://lists.mysql.com/mysql/228534
Message-Id: <5090036B.1050901@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig65CC8FE181B255DB88DD767A"

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



Am 30.10.2012 17:34, schrieb Tim Johnson:
> * Reindl Harald <h.reindl@stripped> [121030 08:25]:
>> if it are MyISAM tables it is the best way because all data
>> are in a folder with the database name - i never in my life
>> used a dump to migrate mysql-databases while started with
>> MySQL-3.x long years ago and moved them between Linux,
>> Windows and MacOSX and we speak about some hundret databases
>> with 5000 tables
>=20
>   Clearly, I have failed to pose my question clearly, because the
>   responses indicate that I have not been understood, so I will try
>   again:
>=20
>   *****************************************************************
>   mysqldump does not recognize the drupal databases!
>     Example :
>       linus:prj tim$ mysqldump event -hlocalhost -utim
>       -pXXXXXX > event.sql
>       mysqldump: Got error: 1049: Unknown database 'event' when
>       selecting the database
>=20
>   mysql does not find the drupal databases!
>   PHPMyAdmin does not find the drupal databases!

your first message:

>The drupal mysql datafiles are located at
> /Applications/drupal-7.15-0/mysql/data
>
> as opposed to /opt/local/var/db/mysql5 for
> 'customary' mysql.

this crap is outside your mysqldata

and that is why it was suggested that you teporary change
the datadir of your mysqld to /Applications/drupal-7.15-0/mysql/data
or if this are only MyISAM-atbles FOR SURE you can simply move
the database folders in your running mysqld-datadir

typical MacOSX-style to throw things around the whole
machine without any logical structure like applications
in the userhome...... this is the price someone has to
pay for a poor operating system without package management


--------------enig65CC8FE181B255DB88DD767A
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/

iEYEARECAAYFAlCQA2sACgkQhmBjz394AnkXUwCeMVuLTCcaioj6I1vRm6sV4jXw
ohQAniqxd/JnRhoMZ2HFbSf0IZu+wIWJ
=CsJe
-----END PGP SIGNATURE-----

--------------enig65CC8FE181B255DB88DD767A--