mattal999 Posted July 10, 2009 Share Posted July 10, 2009 Hi everyone! I'm new to this board, so don't bully me I have a problem. My website, iMuzic.co.uk (You can view it, it doesn't even load that script), was running fine until about 3 hours ago. One of my scripts caused table corruption in the first table. An auto_increment duplicate if i'm not mistaken. This is usually all well and good (happens every now and again), and seeing as I was doing other things I was unaware of it. When I went to my phpmyadmin (Which somehow is still viewable) I tried to login, and voila! Oh. No. It just reloads the page whenever I try and login. Literally. No error messages. Just a new token ID on the url ($_GET variable). I was like 'Oookkk', so I thought well i'll just repair it through PHP. So I wrote a short script to connect, repair the table and close the connection. Uploaded the script. Ran the script. Oh. Just keeps loading for about 10 minutes. Right. I'll set a timeout! Set timeout to 120 seconds. Keeps running for 10 minutes. Set timeout to 10 seconds. Keeps running for 10 minutes. Right. So, I checked my other scripts which looked ok, but to my horror I see that now my second table has corrupted. Not sure what time, but seemed to be because of the corruption of the first table. Damn, now i'm stuck. I tried phpminiadmin to fix it. Logged in ok. Listed tables ok. Click Repair > Script hangs for 10 minutes. Now I seem to get the problem that any of my scripts which connect to the MySQL database and carry out a query hang forever. This is a real bummer, and no, I don't have access to the server. I sent an email to the host (My mate) asking him to restart it ASAP. I think MySQL has hung or something. Any advice on the matter? Thanks, Mattal999 Quote Link to comment https://forums.phpfreaks.com/topic/165539-solved-mysql-seems-to-have-hung-most-of-the-server/ Share on other sites More sharing options...
mattal999 Posted July 10, 2009 Author Share Posted July 10, 2009 Sorry for the double post. but I can't edit my previous (first) one for some reason (Or am I missing something?). My MySQL version is 5.x.x (Can't even get into phpmyadmin to view it and have no cpanel at the moment - Sorry). Quote Link to comment https://forums.phpfreaks.com/topic/165539-solved-mysql-seems-to-have-hung-most-of-the-server/#findComment-873149 Share on other sites More sharing options...
mattal999 Posted July 11, 2009 Author Share Posted July 11, 2009 Never mind. If you have this problem though, it usually means that the hard drive on the server is full. Not sure how it works, but that's what happened to me. Topic solved. Quote Link to comment https://forums.phpfreaks.com/topic/165539-solved-mysql-seems-to-have-hung-most-of-the-server/#findComment-873476 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.