List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 23 2009 2:37pm
Subject:Re: Rename Database - Why Would This Not Work?
View as plain text  
You don't even need to stop the server afaik. As mentioned previously,
though, works for MyISAM only.

On Mon, Nov 23, 2009 at 3:17 PM, 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
>
>

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