List:General Discussion« Previous MessageNext Message »
From:Ranjeet Walunj Date:August 1 2008 9:15am
Subject:Re: Table aliasing
View as plain text  
Richard Heyes wrote:
> Is there a way in MySQL to define an alias for a table, so in effect
> it has two names? For migration purposes.
>   
What exactly do you mean by migration process ?

Do you want to take backup of older tables/databases ?

There are multiple ways of doing the same :

1) use mysqldump
2) mysqlhotcopy
3) use COPY TABLE command to create duplicated tables
4) Set up replication on another server/machine for taking backup
And many other ways ..

Regards,
Ranjeet Walunj

Thread
Table aliasingRichard Heyes1 Aug
  • Re: Table aliasingRanjeet Walunj1 Aug
    • Re: Table aliasingRichard Heyes1 Aug
  • Re: Table aliasingMartijn Tonies1 Aug
    • RE: Table aliasingemierzwa1 Aug
      • Re: Table aliasingRichard Heyes1 Aug
  • Re: Table aliasingMartijn Tonies1 Aug