Re: Changing ibdata files on the fly

At 12:39 +0530 5/3/04, Sp.Raja wrote: Hi List, Is it possible to change data and log files (ibdata and iblogfiles copied for backup purpose) on the fly? No, you must shut down the server cleanly. Will something like this work?? 1. Close all client connections 2. Flush and disable further client

Changing ibdata files on the fly

Hi List, Is it possible to change data and log files (ibdata and iblogfiles copied for backup purpose) on the fly? Will something like this work?? 1. Close all client connections 2. Flush and disable further client connections. 3. Copy ibdata and iblogfiles from backup dir 4. SIGHUP mysqld. Wha