List:General Discussion« Previous MessageNext Message »
From:Eric Robinson Date:November 23 2009 2:17pm
Subject:RE: Rename Database - Why Would This Not Work?
View as plain text  
>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
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