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.robin...@psmnv.com>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=vegiv...@tuxera.be > >