From: Johan De Meersman Date: November 23 2009 2:37pm Subject: Re: Rename Database - Why Would This Not Work? List-Archive: http://lists.mysql.com/mysql/219465 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e6475b20062cfa04790ac4c4 --0016e6475b20062cfa04790ac4c4 Content-Type: text/plain; charset=ISO-8859-1 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 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=vegivamp@stripped > > --0016e6475b20062cfa04790ac4c4--