| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Johan De Meersman | Date: | December 11 2009 1:58pm |
| Subject: | Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE? | ||
| View as plain text | |||
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 :-)