Web Hosting Forum | Lunarpages
News:
+ JULY 4th SPECIAL! Get $50 off your new Basic hosting plan purchase!
+ Vote for the  June 2009 Site of the Month!
+ The June 2009 - Issue 21 Edition of the LP Newsletter has been Published!
+ Read the 10 Things Every Lunarpages Customer Should Know!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
July 04, 2009, 02:59:06 PM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: MySQL Issues  (Read 3101 times)
Jason2
Galactic Royalty
*****
Offline Offline

Posts: 203


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
Business Development Specialist
Senior Moderator
Berserker Poster
*****
Offline Offline

Posts: 10660


your friendly neighborhood moderator guy!


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

Stickied this, thanks again Jason!
Logged

USA! USA! - Save $50 on any NEW Basic hosting plan purchase! (Happy 4th of July!)

Foolish Mitch the Moderator - follow us @lunarpages on Twitter!
Important Threads: Read This Before Posting! | Lunarforums Rules! | Site of the Month Contest
Also, be sure to check out and subscribe to the Lunartics Blog and the Lunarpages Newsletter !
Jason2
Galactic Royalty
*****
Offline Offline

Posts: 203


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
vks87
Intergalactic Cowboy
*****
Offline Offline

Posts: 63


« Reply #3 on: April 01, 2009, 11:42:16 PM »

Thanks for the links..
and ofcourse for the article..
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC

2009 © Lunarpages.com
Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM