[Forum] Database error

[JackieChun]

Hey guys, can you help me troubleshoot this? The site just went down all of a sudden, possibly due to something I just did. I need to get the site back up as soon as possible.

This is the error.

	Database error
The Forum database has encountered a problem.
Please try the following: Load the page again by clicking the Refresh button in your web browser. Open the home page, then try to open another page. Click the Back button to try another link.
The forum technical staff have been notified of the error, though you may contact them if the problem persists.

I migrated this site via cPanel to a new server several days ago, and the restore went fine. The nameservers were changed successuflly, and everything was pointed to the new server. Today I was about to shut down the old server, and after I deleted the old cPanel account, this error started happening. That doesn't make sense because nothing should be pointing to the old IP anymore. I would appreciate any help with this.

[Zachery]

Everytime a database error occurs, you should get a copy of it to the techemail on file. Are you?

[JackieChun]

There is a tech contact listed in config.php but I believe this is a moderator who hasn't been with the site in a long time.

- - - Updated - - -

OK, I've changed the email address, and here is the error. It's coming pretty fast from every script imaginable.

MySQL Error : Can't create/write to file '/home/mysqltmp/#sql_205d_0.MYI' (Errcode: 2)
Error Number : 1
Request Date : Wednesday, August 22nd 2012 @ 08:44:56 PM
Error Date : Wednesday, August 22nd 2012 @ 08:44:56 PM
...
Username : Unregistered
Classname : vB_Database
MySQL Version :

[Zachery]

You need to contact your webhost ASAP.

root@heimdall:~# perror 2
OS error code 2: No such file or directory

[JackieChun]

I have root access and I see all the databases still there, so no reason to panic just yet. However, this triggered my memory that I was tidying up the leftover folders after the migration and might have deleted a temporary directory or two. This may be related to that.

- - - Updated - - -

We have re-created that directory with proper permissions and the forum started working. Solved!