RE: Rename Database - Why Would This Not Work?

[Eric Robinson]

>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