From: Johan De Meersman
Date: December 11 2009 1:58pm
Subject: Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?
List-Archive: http://lists.mysql.com/mysql/219661
Message-Id: <aaba5c100912110558h28e6f0bfmb6eb136c6dab3b1b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0015176f13b62ee234047a74513d

--0015176f13b62ee234047a74513d
Content-Type: text/plain; charset=ISO-8859-1

On Fri, Dec 11, 2009 at 1:56 PM, Ken D'Ambrosio <ken@stripped> wrote:

> > rename table oldschema.table to newschema.table;
>
> Just to be 100% clear -- I assume you have to first create the destination
> database, and then do this for all the tables in the source database?
>

Yep. Easily scriptable, though :-)

--0015176f13b62ee234047a74513d--