List:General Discussion« Previous MessageNext Message »
From:Tom Worster Date:June 3 2010 9:01pm
Subject:replication of RENAME TABLE d1.t TO d2.t
View as plain text  
i've a need to change the name of a database and haven't done this before in
our live server.

while the tables are myisam, i'm not inclined to rename the dirname of d1's
datafiles because i'd rather not interrupt service for other databases and
i'd prefer if the renaming would replicate.

can i do it like this:

in the application, kick users of d1 out
create database d2
foreach t in d1:
    RENAME TABLE d1.t TO d2.t
tell user to use d2

?

tom


Thread
replication of RENAME TABLE d1.t TO d2.tTom Worster3 Jun
  • Re: replication of RENAME TABLE d1.t TO d2.tMichael Dykman3 Jun