The FreeBSD Diary

The FreeBSD Diary (TM)

Providing practical examples since 1998

If you buy from Amazon USA, please support us by using this link.
[ HOME | TOPICS | INDEX | WEB RESOURCES | BOOKS | CONTRIBUTE | SEARCH | FEEDBACK | FAQ | FORUMS ]
FreeBSD Support
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Newer Topic  |  Older Topic 
 problem in 'lock table' (php+mysql)
Author: alamsyah 
Date:   12-04-00 16:53

I just finished my php script,
something look like this :

.....
mysql_db_query($dbname,"lock tables table1 write, table2 write, table3 write",$conn);
$result = mysql_db_query($dbname,"select * from table1",$conn);
....

in the middle of my script I accidently put
this : exit();
without unlocking the tables first !

and the next time I call my script,
It's just sitting there waiting for the reply,
I think it's because of the lock mechanism,
the question is how can I unlock the tables, while I don't have superuser account,
I know this solution, restart the server, but it doesn't seem to be nice.

Could You Help Me, Please . . . .


Reply To This Message
 Forum List  |  Threaded View   Newer Topic  |  Older Topic 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
How to get the most out of the forum

phorum.org