Web Hosting Forum | Lunarpages
News: October 6, 2008 - Submit Your Site for the October 2008 Site of the Month!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
October 11, 2008, 12:12:29 PM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: MySQL Issues  (Read 2257 times)
Jason2
Intergalactic Superstar
*****
Offline Offline

Posts: 199


WWW
« on: March 06, 2008, 11:18:33 AM »

Can't connect to local MySQL server through socket

This means:

1. MySQL crashed, it's not running or it can't find the socket. You need to contact Lunarpages support about this.

2. If your running a vBulletin board, then it means the info in your config.php file is wrong (in which case your forums wouldn't work at all).

Here is more info on this error:

MySQL 5.1:
http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html

MySQL 5.0:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html

MySQL 3.23, 4.0, 4.1:
http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html

In Windows:
http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server-on-windows.html
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server-on-windows.html

Lost connection to MySQL server during query

Below are some of the most common reasons to receiving this error:

1. Because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection. You can check that the MySQL hasn't died by executing mysqladmin version and examining the uptime.

2. Are you trying to run a query against your database that is either incorrect or too large? If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection.

3. Or your host has restarted mySQL. If this is the case, just simply contact the wonderful LunarPages support!

Useful links:
http://www.mysql.com/doc/C/o/Common_errors.html
http://www.mysql.com/doc/G/o/Gone_away.html
http://www.mysql.com/doc/S/e/Server_parameters.html
http://www.mysql.com/doc/O/p/Option_files.html
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
http://dev.mysql.com/doc/

I'll add more when I get around to doing so.

Regards Jason Smile
« Last Edit: March 06, 2008, 12:19:58 PM by Jason2 » Logged

"Anyone who has never made a mistake has never tried anything new." -- Albert Einstein
Mitch
Lunarpages Traffic Cop
Senior Moderator
Berserker Poster
*****
Offline Offline

Posts: 7949



WWW
« Reply #1 on: March 06, 2008, 11:39:18 AM »

Stickied this, thanks again Jason!
Logged

Jason2
Intergalactic Superstar
*****
Offline Offline

Posts: 199


WWW
« Reply #2 on: March 06, 2008, 11:43:55 AM »

Not a problem at all Mitch.

Thanks!

Regards Jason Smile
Logged

"Anyone who has never made a mistake has never tried anything new." -- Albert Einstein
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.6 | SMF © 2006-2008, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM