> As long as two databases are on the same disk you can also rename from one > database to another: > RENAME TABLE current_db.tbl_name TO other_db.tbl_name;
Works!! :-) But the thing is: by doing this, although the tables have been *moved* from the old database to the new one, the old database still exists and I'll have to drop it separately. -------- So, this should NOT be called *rename*. The procedures involved are: create a new database -> move the tables from the old_database to the new_database. Funny. :-) thanks Heikki. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]