From: Johan De Meersman Date: May 24 2011 3:51pm Subject: Re: Renaming a database? List-Archive: http://lists.mysql.com/mysql/225090 Message-Id: <8d495da0-ce8a-4122-882f-9018ba63e4b1@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable ----- Original Message ----- > From: "Jerry Schwartz" > > It looks like there=E2=80=99s no way to rename a database. Is that true? Yes. Silly oversight, although there's probably complexity reasons behind i= t. > - I want to get a current version of a database out of the way so > that I can load in an older version, without having to pay the > penalty of reloading the current version. That precludes "rename table db1.blah to db2.blah", I guess - it basically = copies the whole thing and then kills the old one. Slowwwwww for big tables= :-) > - I think I have a database that isn=E2=80=99t being used (don=E2=80=99t = ask), and I > want to hide it to see if anything blows up. If you are in a position to shut your server down, you may rename the datab= ase directory while it's down IF you only use MyISAM tables. If you have InnoDB tables, you're stuck with dump/reload or rename table. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel