create or rename table or database

[Richard]

Hi,

in the database I have 3 tables t1, t2, t3.
I want to make 3 new empty tables with the same structure.
Insert data. RENAME the 3 in use to 't(x)_old' and RENAME the new to t(x). Of course I can do a CREATE and RENAME .

I saw " CREATE TABLE new_table (...); " in the MySQL Reference manual, which should create a new empty table with the same structure. But it doesn't work. How do you have to refer to the old table.

Is it possible to RENAME a database? Or even create the whole database with the same structure as the old database?

Richard