update problem

Reply

Join Date: Jan 2006
Posts: 2
Reputation: albert85 is an unknown quantity at this point 
Solved Threads: 0
albert85 albert85 is offline Offline
Newbie Poster

update problem

 
0
  #1
Jan 3rd, 2006
i'm a newbie in MySQL. i want to know if i want to update MYSQL, can i check that is it have any user at that time, provide me the solution. if i get there is the user how i block the traffic and wait for the user finish their transaction theni close down the server? provide me the solution on it. thank you...

regards,
albert
Reply With Quote Quick reply to this message  
Join Date: Mar 2005
Posts: 131
Reputation: william_stam is an unknown quantity at this point 
Solved Threads: 2
william_stam's Avatar
william_stam william_stam is offline Offline
Junior Poster

Re: update problem

 
0
  #2
Jan 15th, 2006
SHOW PROCESSLIST;

then

KILL ???

??? being the id value for the process
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MySQL Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC