On Thu, Mar 07, 2002 at 12:08:29AM -0500, Mr. Ozette Brown wrote: > > I'm in the process of converting all of my database tables from ISAM > to MYISAM table format. I'll run the mysql_convert_table_format > script which basically does an "Alter table". If during this > conversion someone accessed a web page which writes to the database > (insert or update), what will happen? Will the affected tables > become corrupt or will MySQL lock the table, perform the Alter, then > unlock the table so the table can be inserted or updated?
MySQL will lock the tables for you. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 27 days, processed 977,994,364 queries (408/sec. avg) --------------------------------------------------------------------- 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
