From: Ranjeet Walunj
Date: August 1 2008 9:15am
Subject: Re: Table aliasing
List-Archive: http://lists.mysql.com/mysql/213953
Message-Id: <4892D416.6060800@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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