From: Reindl Harald
Date: July 20 2012 9:51am
Subject: Re: Disable DB without deleting data
List-Archive: http://lists.mysql.com/mysql/227860
Message-Id: <50092A0F.1080002@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigE108E4441D2731F6F79F2E0A"

--------------enigE108E4441D2731F6F79F2E0A
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable



Am 20.07.2012 11:20, schrieb Johan De Meersman:
>=20
> ----- Original Message -----
>> From: "Reindl Harald" <h.reindl@stripped>
>>
>> impossible with innodb
>>
>> * dump
>> * delete
>>
>> with myisam you could stop the server and move the databasedir
>> do not try this with innodb even with innodb_file_per_table!
>=20
> Mmh, it should be pretty easy to write a small script that creates a ne=
w database named <oldname>_offline and renames all tables into it, no?
>=20
> Shame that "rename database" doesn't exist any more :-)

my reply was to "Something like moving the databases subdirectory to a di=
fferent directory"

surely, you can rename the database
but if you want to move it to another mount-point you are lost with innod=
b


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

iEYEARECAAYFAlAJKg8ACgkQhmBjz394Ank/NwCginuvvrVoEY2I+CGu8c+mYuBS
NeMAnAnJcBwlu4d8+5Obxl23fhddYmiz
=NXEV
-----END PGP SIGNATURE-----

--------------enigE108E4441D2731F6F79F2E0A--