MySQL stopped working

[feld0_x10]

Hello. I just got an issue with an old e-mail account solved, but a new issue with my forum's SQL database just popped up.

Thing is, my forum stopped working completely several minutes ago (from the time I posted this message), and now just displays the attached error message whenever I try to do anything on it. Going into my cPanel, it tells me that I have one out of three allotted SQL databases on my account, but the MySQL Databases page doesn't list any.

What happened? Has the database been deleted or corrupted or something? If it helps, the forum software I use is phpBB3. The forum is supposed to be at the subdomain http://forums.feld0.co.cc/, but it will only give you the attached error if you try to visit.

One more thing: my FTP account has disappeared, too, but unlike the SQL database, it hasn't left any trace whatsoever in my cPanel.

Thank you!
~Feld0

P.S.: I backed up the database last night, so if it's been deleted, I can restore a fairly recent version of it.

EDIT: Nevermind...the forums started working again and the database came back. However, the issue I described above seems to occur at least once per day. Is there any explanation as to why this happens?

 

[descalzo]

You have any sort of automated backup going?

EDIT/ADD:

Just thinking out loud...
You are on one of the new servers, where most of the new accounts are put.
New accounts put more load on the system by creating dbs, etc.
When several new accounts import db's at the same time, it might cause the slowdown.
The Admins might want to look into this.

 

[feld0_x10]

I use phpBB's built-in backup feature to back up my database to a folder in the public_html directory. I back it up there about twice a day, and download a backup file to my computer every two days. No automation, sadly.

So the problem is simply related to excessive server load?

 

[Livewire]

I use phpBB's built-in backup feature to back up my database to a folder in the public_html directory. I back it up there about twice a day, and download a backup file to my computer every two days. No automation, sadly.

So the problem is simply related to excessive server load?

He's not sure, he's suggesting that as a possibility. It's one worth investigating I think though - even if it's not excessive load it might not hurt to peek and make sure the Boru sql setup is holding out as well as the other servers. Boru's new so many something's not quite 100% efficient somewhere.

It's not something you're causing I don't think though - there's others on that server reporting problems here and on IRC as well.

 

[Corey]

Change your MySQL server to use localhost

 

[feld0_x10]

If you don't mind me asking, how exactly would I do that? Is it a parameter somewhere in the cPanel?

Sorry, this is my first time ever using MySQL (or SQL, period.).

 

[Zubair]

Edit you config.php file. It should be in phpbb root dir.

It should be look like this after edit

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'cpuser_dbname';
$dbuser = 'cpuser_dbuser';
$dbpasswd = '(password is hidden)';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

 

[feld0_x10]

Thanks for the instructions (hope I'm not being too n00bish!). I changed the entry in the config file to "localhost." I'll see if the forum goes offline again later.

What exactly is the effect of this change, though? How will it make the SQL database more reliable?
Sorry, I just like to know exactly what I'm doing here.

 

[Zubair]

After MYSQL server upgrade mysql-[server].x10hsoting.com is not working. Only localhost is working.

So thats why many people having this issue.

What do you mean by making database reliable??

 

[feld0_x10]

Oh. Never mind what I said about reliability; I'm just a total n00b to web design.