Other way around.
Assuming the aplcation is expecting your table to be named 'db.table1'
and your replacement is newdb.table1 you can do the following.
create a database for hold archives
CREATE olddb;
then
RENAME TABLE
db.table1 to olddb.table1, -- back up the current table
newdb.table1 to d
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
On Thursday 28 February 2002 02:57 am, Christian Rabe wrote:
> Hi,
>
> I just run into a "problem".
>
> RENAME TABLE put_tablename_here TO another_tablename here
>
> is not replicated. But a
>
> ALTER TABLE RENAME put_tablename_here TO another_tablename here
>
> is replicated.
>
> Is this a
On Thursday 28 February 2002 02:57 am, Christian Rabe wrote:
> Hi,
>
> I just run into a "problem".
>
> RENAME TABLE put_tablename_here TO another_tablename here
>
> is not replicated. But a
>
> ALTER TABLE RENAME put_tablename_here TO another_tablename here
>
> is replicated.
>
> Is this a
Hi,
I just run into a "problem".
RENAME TABLE put_tablename_here TO another_tablename here
is not replicated. But a
ALTER TABLE RENAME put_tablename_here TO another_tablename here
is replicated.
Is this a "feature", or do I something wrong ?
Regards
PS (Filter): Mysql is the greatest data
