My SQL databases are gone!

thefictionalme · August 17th, 2004, 1:36 PM

I went to update in my Wordpress and noticed an error:

Quote:

Error establishing a database connection! This probably means that the connection information in youn wp-config.php file is incorrect. Double check it and try again.

So then I went to my site and got this:

Quote:

<?xml version="1.0" encoding="iso-8859-1" ?>
- <div>
- <p>
<strong>Error establishing a database connection!</strong>
This probably means that the connection information in youn
<code>wp-config.php</code>
file is incorrect. Double check it and try again.
</p>
- <ul>
<li>Are you sure you have the correct user/password?</li>
<li>Are you sure that you have typed the correct hostname?</li>
<li>Are you sure that the database server is running?</li>
</ul>
- <p>
<a href="http://wordpress.org/support/">WordPress Support Forums</a>
</p>
</div>

So then I realized something was really up so I went to my cpanel and it says I have 0 mySQL databases and I get this error:

Quote:

DBI connect('mysql:localhost','root',...) failed: Too many connections at /usr/local/cpanel/Cpanel/Mysql.pm line 42 ERROR 1040: Too many connections ERROR 1040: Too many connections ERROR 1040: Too many connections /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Too many connections' ERROR 1040: Too many connections ERROR 1040: Too many connections ERROR 1040: Too many connections ERROR 1040: Too many connections /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Too many connections' ERROR 1040: Too many connections ERROR 1040: Too many connections

I have not messed with my database or anything, what is going on? Please don't tell me I lost everything!!

http://www.thefictionalme.com
Jenny

**bassdaddy777** · August 17th, 2004, 1:49 PM

support[at]surpasshosting[dot]com

It would be really strange if they were gone. More likely it's just not connecting - for whatever reason.

thefictionalme · August 17th, 2004, 1:51 PM

It says on my left side menu that I have 0 databases/unlimited and it shows no databases on my mySQL page, just the error. I will email support.

**Dave** · August 17th, 2004, 3:13 PM

Too many connections? If it's persistant, support needs to know about that. All the other sites on that server that use MySQL will have the same problem.

And it's showing 0 databases because it can't connect to the server and see how many databases you have.

thefictionalme · August 17th, 2004, 3:15 PM

Yeah it seems to be fine now. I emailed support and never heard anything back... very odd.

**Dave** · August 17th, 2004, 3:18 PM

Then, it was probably because some MySQL-extensive site was hogging the server.

**sam** · August 17th, 2004, 4:59 PM

Hi thefictionalme

That error you got doesn't mean the databases were ever in fact gone.

Either
1) The MySQL server got wedged and needed a restart or was being restarted
2) There really were too many open MySQL connections on that particular server at that instant.

In any case - you did the right thing and emailed support.

**Dave** · August 17th, 2004, 5:03 PM

Sam needs to pay more attention to the usernames. :lol3:

**sam** · August 17th, 2004, 6:19 PM

indeed. i'll fix that in a sec. gremlins i tell you. gremlins.

August 17th, 2004, 1:49 PM	#2 (permalink)
bassdaddy777 The Coolness Excelling Contributor Joined in May 2003 Lives in Sandpoint, Idaho Hosted on Dime5 862 posts Gave thanks: 0 Thanked 0 times	support[at]surpasshosting[dot]com It would be really strange if they were gone. More likely it's just not connecting - for whatever reason. __________________ Bronze Reseller Pass36

August 17th, 2004, 3:13 PM	#4 (permalink)
Dave Third Plateau Comfy Contributor Joined in Apr 2004 Lives in East Hanover, New Jersey Hosted on Nifty 272 posts Gave thanks: 0 Thanked 0 times	Too many connections? If it's persistant, support needs to know about that. All the other sites on that server that use MySQL will have the same problem. And it's showing 0 databases because it can't connect to the server and see how many databases you have. __________________ site (syberdave.net) - server (nifty)

August 17th, 2004, 3:18 PM	#6 (permalink)
Dave Third Plateau Comfy Contributor Joined in Apr 2004 Lives in East Hanover, New Jersey Hosted on Nifty 272 posts Gave thanks: 0 Thanked 0 times	Then, it was probably because some MySQL-extensive site was hogging the server. __________________ site (syberdave.net) - server (nifty)

August 17th, 2004, 5:03 PM	#8 (permalink)
Dave Third Plateau Comfy Contributor Joined in Apr 2004 Lives in East Hanover, New Jersey Hosted on Nifty 272 posts Gave thanks: 0 Thanked 0 times	Sam needs to pay more attention to the usernames. :lol3: __________________ site (syberdave.net) - server (nifty)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

August 17th, 2004, 1:51 PM	#3 (permalink)
thefictionalme Registered User Fresh Surpasser Joined in Jun 2004 Hosted on dizinc 9 posts Gave thanks: 0 Thanked 0 times	It says on my left side menu that I have 0 databases/unlimited and it shows no databases on my mySQL page, just the error. I will email support.

August 17th, 2004, 3:15 PM	#5 (permalink)
thefictionalme Registered User Fresh Surpasser Joined in Jun 2004 Hosted on dizinc 9 posts Gave thanks: 0 Thanked 0 times	Yeah it seems to be fine now. I emailed support and never heard anything back... very odd.

August 17th, 2004, 4:59 PM	#7 (permalink)
sam Surpass Fan Super #1 Joined in Dec 2003 Lives in NJ 5,057 posts Gave thanks: 0 Thanked 4 times	Hi thefictionalme That error you got doesn't mean the databases were ever in fact gone. Either 1) The MySQL server got wedged and needed a restart or was being restarted 2) There really were too many open MySQL connections on that particular server at that instant. In any case - you did the right thing and emailed support.

August 17th, 2004, 6:19 PM	#9 (permalink)
sam Surpass Fan Super #1 Joined in Dec 2003 Lives in NJ 5,057 posts Gave thanks: 0 Thanked 4 times	indeed. i'll fix that in a sec. gremlins i tell you. gremlins.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)