Re: renaming a mysql database
Yes, that is the correct way to move tables between schemas. You should never move the physical files in the data directory. Having all the tables, comma separated, in a single rename statement will make it atomic.
Subject
Views
Written By
Posted
2203
May 04, 2012 05:59AM
1580
May 04, 2012 08:56AM
1042
May 05, 2012 01:38PM
Re: renaming a mysql database
958
May 14, 2012 12:11PM
1044
May 05, 2012 08:59PM
1377
May 07, 2012 04:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.