Hardi
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
--
George
-----Original Message-----
From: Hardi OK [mailto:hahahardididi@stripped]
Sent: Thursday, May 04, 2006 11:19 PM
To: mysql@stripped
Subject: How to rename a DB
Hi,
Anybody know how can i safely and easily rename a database in MySQL
5.0.19.
Have tried some tips from google results (most of them are for MySQL
4.x)
but no luck till now.
Any help would be greatly appreciated.
Rgds/Hardi
