Welcome Guest ( Log In | Register )



 
Closed TopicStart new topic
> Problem With MySQL
BitShift
post Nov 1 2006, 09:49 PM
Post #1


Advanced Member
Group Icon

Group: Members
Posts: 153
Joined: 8-May 06
From: Houston, TX
Member No.: 13,291



I tried to visit my website today and I recieved the dreadful page from my php-nuke site

"There seems to be a problem with the MySQL database"

First I thought, "no big deal server is probably rebooting or down for a little bit" So i logged into my cpanel and clicked on "Server Status".

Thats when I started worrying. It said the MySQL servers were up and runnign fine. I went back to my main page and looked at my MySQL server count and instead of saying 2/99 it now says NA/99

I am unable to create a new database and I recieve this error when I click on PHPmyadmin
QUOTE

phpMyAdmin - error
#1040 - Too many connections


This is a huge problem for me because my website uses PHP-Nuke and it cannot display anything except for an error page without access to the database. Hopefully the data is not lost because my backup is a few days old.

Anyone else having this problem, and what do I do to fix this?
Go to the top of the page
 
+Quote Post
pyost
post Nov 1 2006, 09:55 PM
Post #2


Nenad Bozidarevic
Group Icon

Group: [MODERATOR]
Posts: 1,043
Joined: 7-November 05
From: Belgrade, Serbia
Member No.: 9,500
myCENTs:38.31



Same here.. I have had this problem on another server, but it usually lasted for only a few minutes. I don't know why the server is taking so long to recover.
Go to the top of the page
 
+Quote Post
tezza
post Nov 1 2006, 10:00 PM
Post #3


Member - Active Contributor
Group Icon

Group: Members
Posts: 88
Joined: 1-November 06
From: kent, U.K
Member No.: 16,912



I think the whole servers are having issue problems. Dont worry about it. However did you take backups just in case?
Give them a while as I think the admins are trying to sort these problems now.
However Im just a newbie so dont listen to me. lol
Hopefully it is alrite.
Go to the top of the page
 
+Quote Post
BitShift
post Nov 1 2006, 10:49 PM
Post #4


Advanced Member
Group Icon

Group: Members
Posts: 153
Joined: 8-May 06
From: Houston, TX
Member No.: 13,291



Yes of course I have backups but the problem here is I can not even make a new database to put the backup on.

The MySQL service for me is completely shut down, and even if I did manage to create a new database the PHPMyAdmin is also not working so there would be know way to upload my backup file to the database.
Go to the top of the page
 
+Quote Post
Mark420
post Nov 1 2006, 10:57 PM
Post #5


The Modernator
Group Icon

Group: Members
Posts: 486
Joined: 6-August 06
From: The Interweb!
Member No.: 15,021



but hey guess what? the easiest and fastest way to backup your DB is to use a CRON job...guess what has NOT been working since the CPANEL upgrade?

Yes go to the top of the class!!! the cron jobs DO NOT run at all these days...not a good thing!!!!this needs to be fixed also!!!
Go to the top of the page
 
+Quote Post
BitShift
post Nov 2 2006, 12:22 AM
Post #6


Advanced Member
Group Icon

Group: Members
Posts: 153
Joined: 8-May 06
From: Houston, TX
Member No.: 13,291



Well the MySQL issue seems to be resolved as my website is back up and running with no data loss.

I would like to thank the site administrators and anyone who contributed to getting this done in a timely fashion.

As for the cron jobs well the best of luck to you on that.
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. General Problems With New Account(2)
  2. Problem With Mysql(6)
  3. MySQL Database(3)
  4. IPS Driver Error / MySQL Database(1)
  5. Can I Access MySQL Database From Outsite, Directly(10)
  6. MySQL - Can't Connect(1)
  7. Problem With MySQL Not Being Able To Connect(9)
  8. Weird MySQL Message(4)
  9. Help Me!(3)
  10. Mysql Error Never Seen On My Site Before (too Many Connections).(13)
  11. Mysql Connect Error, Too Many Connections.(1)
  12. Php And Mysql Version.(7)
  13. What Is The MySQL Version @ Asta ?(16)
  14. Site Not Opeing ( Phpbb Forum) :: Can't Connect To Local Mysql(3)
  15. Mysql Server Not Stable After Hard Disk Swap On April 6th(2)
  1. Connecting To Astahost's Mysql(8)


 



- Lo-Fi Version Time is now: 23rd November 2008 - 12:11 AM