LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   MySQL frig-up (https://www.linuxquestions.org/questions/linux-software-2/mysql-frig-up-54353/)

Citizen Bleys 04-10-2003 06:06 AM

MySQL frig-up
 
I suffered an error that crashed my browser while I was writing to the database on a php/MySQL-driven message board (Not the same as LQ.org is using, but one written by a high-school student in Québec), and now the board doesn't work anymore.

In phpMyAdmin, the "posts" table is listed as "in use"...I'm assuming that I aquired a lock on the db for writing, and then the browser crashed before the lock could be released

Does anybody know how to force that lock to be released? I can't use the db again until it is.

(If it's relevant, I'm using whatever version of MySQL came with Red Hat 8)

bulliver 04-10-2003 11:49 AM

Why not just restart mysql, will that not work? If you are using redhat should be as easy as 'mysqld restart'


All times are GMT -5. The time now is 10:21 PM.