But my updates are coming from a web server on the localhost so will this still block connections? Sounds like the answer is no.
I forgot to say that I am running MySql 5.0 on Solaris 10 if that makes a difference. -----Original Message----- From: Rolando Edwards [mailto:redwa...@logicworks.net] Sent: Wednesday, May 20, 2009 4:13 PM To: TETTERTON George; mysql@lists.mysql.com Subject: RE: Starting MySQL in Maintenance mode Do 'service mysql restart --skip-networking' This prevents all TCP/IP connections You can login as r...@localhost and the client program will use the socket file rather than TCP/IP. Do all your DDL work. When done, 'service mysql restart' Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net -----Original Message----- From: TETTERTON George [mailto:george.tetter...@alcatel-lucent.com] Sent: Wednesday, May 20, 2009 4:30 PM To: mysql@lists.mysql.com Subject: Starting MySQL in Maintenance mode How do I start MySQL in maintenance/single user mode so I can create indexes on a table that is being updated often? I prefer for the update transactions to fail immediately with a connection error rather than to wait for a lock to be released. In Oracle you can startup nomount. What is the equivalent for MySQL? George Tetterton Alcatel-Lucent 3400 W. Plano Pkwy Plano, TX 75075 Office: 972-477-1571 Cell: 972-400-0887 Email: george.tetter...@alcatel-lucent.com <blocked::mailto:george.tetter...@alcatel-lucent.com> Yahoo Messenger ID: george_tetterton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org