List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 17 2002 1:21am
Subject:Re: Alter (MyISAM) table while clients connected?
View as plain text  
At 10:55 +1000 4/17/02, Daniel Kasak wrote:
>Hi all.
>Can I alter a MySQL table (specifically a MyISAM) table while (MS 
>Access) clients are connected?
>I want to add fields, not alter existing ones.
>Is this likely to cause corruption?
>Thanks!

MySQL won't alter the table until it can get a write lock for exclusive
use.  You won't corrupt the table, though the ALTER TABLE may block
while it waits for the lock.

>
>Dan
>--
>Daniel Kasak
>IT Developer
>* NUS Consulting Group*
>Level 18, 168 Walker Street
>North Sydney, NSW, Australia 2060
>T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
>email: dkasak@stripped
>website: www.nusconsulting.com

Thread
Alter (MyISAM) table while clients connected?Daniel Kasak17 Apr
  • Re: Alter (MyISAM) table while clients connected?Paul DuBois17 Apr