I rotate tables out on a monthly basis. The way I do it is:
rename table1 to table2
If you need a new copy of table1, you can do :
create table table1 like table2
From: Hardi OK [mailto:hahahardididi@stripped]
Sent: Thursday, May 04, 2006 11:19 PM
Subject: How to rename a DB
Anybody know how can i safely and easily rename a database in MySQL
Have tried some tips from google results (most of them are for MySQL
but no luck till now.
Any help would be greatly appreciated.