List:General Discussion« Previous MessageNext Message »
From:Jim Lyons Date:November 23 2009 2:37pm
Subject:Re: Rename Database - Why Would This Not Work?
View as plain text  
Does this work if any of the tables are InnoDB?

On Mon, Nov 23, 2009 at 8:17 AM, Robinson, Eric <eric.robinson@stripped>wrote:

> >RENAME TABLE
> >   olddb.table1 TO newdb.table1,
> >   olddb.table2 TO newdb.table2
>
> >put the whole list in here, the whole statement will be applied to the
> system atomically
>
> The database has 1200+ tables, so your approach seems like more work to
> me. As it is, all I'm doing is:
>
> service mysql stop
> mv olddb newdb
> service mysql start
> mysqlcheck -o newdb
>
>
> --
> Eric Robinson
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

Thread
Rename Database - Why Would This Not Work?Eric Robinson21 Nov
  • Re: Rename Database - Why Would This Not Work?Rob Wultsch21 Nov
RE: Rename Database - Why Would This Not Work?Eric Robinson21 Nov
  • Re: Rename Database - Why Would This Not Work?Rob Wultsch22 Nov
    • Re: Rename Database - Why Would This Not Work?Michael Dykman22 Nov
RE: Rename Database - Why Would This Not Work?Eric Robinson23 Nov
  • Re: Rename Database - Why Would This Not Work?Jim Lyons23 Nov
  • Re: Rename Database - Why Would This Not Work?Johan De Meersman23 Nov
    • Re: Rename Database - Why Would This Not Work?Rob Wultsch23 Nov