The rename scenario is your best option. Just make sure you flush the tables to ensure that users are seeing current data. You normally do not want to `pull the rug` out from your users by deleting a table that they may be attempting to access.
-----Original Message----- From: Haitao Jiang To: [EMAIL PROTECTED] Sent: 8/9/04 12:42 AM Subject: What would happen in these two cases? I hope this is not a so dumb question: Case 1: I have a table A under a running MySQL 4.1.3b server. If I replace A.MYD and A.MYI files without stop and start the server, will data gets corrupted? Case 2: I rename A to A1, and A2 to A, assume A, A2 have the same schema but different data/index. Is it bad? Will data gets corrupted? I tied this one, it seems ok. In both cases, there will be some queries on A, but no updates. Thanks Haitao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
