renaming table in database, restoring data to table

[csross]

I am new at mysql.

A consultant recently hired at my company overlayed/wiped- out a table in a database I created for him. This database was a copy of a live database so I have the original table data he deleted.

How do I rename the product table he created to os-product, it must live in the same database?

How do I create a the product table and import the original data from the live database?

Any help would be appreciated.
Csross

 

[vanekl]

To rename a table:

alter table product rename os-product;


To create a table based on your 'live' table:

create table product select * from yourlivedatabase.product;

[This assumes both databases are located on the same machine.]