From: Johan De Meersman Date: December 11 2009 9:58pm Subject: Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE? List-Archive: http://lists.mysql.com/mysql/219676 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00151774041c4e4a00047a7b0569 --00151774041c4e4a00047a7b0569 Content-Type: text/plain; charset=ISO-8859-1 On Fri, Dec 11, 2009 at 10:40 PM, Daevid Vincent wrote: > Will this work in 5.0? > Yes. > If I'm reading this right, it seems like this is some kind of trick or > loophole then right? If it works and solves my dilemna, I'm fine with that, > but I'm just curious. > Not really, this is by design afaik. > How fast is this? I mean, if I have an 80GB database, is it like a real > unix 'mv' command where it simply changing pointers or is it a full on > copy/rm? (Assume same filesystem/directory) > Don't know, but given that it works with InnoDB, you should be able to easily test on a small dataset by monitoring the size of a 1M autoextend tablespace :-) --00151774041c4e4a00047a7b0569--