Does this work if any of the tables are InnoDB? On Mon, Nov 23, 2009 at 8:17 AM, 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=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com