List:General Discussion« Previous MessageNext Message »
From:Rolando Edwards Date:May 20 2009 9:13pm
Subject:RE: Starting MySQL in Maintenance mode
View as plain text  
Do 'service mysql restart --skip-networking'

This prevents all TCP/IP connections

You can login as root@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
redwards@stripped

-----Original Message-----
From: TETTERTON George [mailto:George.Tetterton@stripped] 
Sent: Wednesday, May 20, 2009 4:30 PM
To: mysql@stripped
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.tetterton@stripped
<blocked::mailto:george.tetterton@stripped> 
Yahoo Messenger ID: george_tetterton
 
Thread
Starting MySQL in Maintenance modeTETTERTON George20 May
  • RE: Starting MySQL in Maintenance modeRolando Edwards20 May
    • RE: Starting MySQL in Maintenance modeTETTERTON George21 May