Re: Is rename table to another database safe for INNODB tables

2003-01-21 Thread Heikki Tuuri
Jannie, - Original Message - From: Jannie Qu [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, January 21, 2003 1:30 AM Subject: Is rename table to another database safe for INNODB tables sql, query, Hi, all, As you may knew, mysql will implement rename database

Is rename table to another database safe for INNODB tables

2003-01-20 Thread Jannie Qu
sql, query, Hi, all, As you may knew, mysql will implement rename database in version 4.1 Right now, I need to rename a database, what I plan to do is rename each table (INNODB type, version 3.23.53 on MAC OS) to another new database. RENAME TABLE current_db.tbl_name TO new_db.tbl_name; Do