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" 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 you think it's safe to (1) do the rename? or I'd better do a (2) import > all to the new database? Which way is better? RENAME is safe. > Thank you, > Jannie Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php