From: Reindl Harald Date: October 30 2012 4:24pm Subject: Re: Dumping drupal databases List-Archive: http://lists.mysql.com/mysql/228532 Message-Id: <508FFF48.70501@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig0C27001D8F1636D2D270B294" --------------enig0C27001D8F1636D2D270B294 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 30.10.2012 17:17, schrieb Hassan Schroeder: > On Tue, Oct 30, 2012 at 9:12 AM, Tim Johnson wrote:= >=20 >> I might try cp -p -r, but need a second opinion. >=20 > If you want to dump one or more databases, presumably you know > the name(s); just use the mysqldump utility. Copying files is not the > optimal way to save your data for most use cases. 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 --------------enig0C27001D8F1636D2D270B294 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/ iEYEARECAAYFAlCP/0gACgkQhmBjz394Anm71gCdHo8W9ZN+o8wk5yBy38P1QMJJ 9Z0An0PYjfo+ZuvupM9aOYWGfXOXW7Ek =kNi8 -----END PGP SIGNATURE----- --------------enig0C27001D8F1636D2D270B294--