Re: Table aliasing

[Ranjeet Walunj]

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