...

View Full Version : xampp upgrade causing error 2002 on 1 table only!



Stooshie
06-09-2011, 04:10 PM
I have been using xampp for years for development purposes, with no problems.

I upgraded to XAMPP 1.7.4 recently, as I needed php 5.3.x, and everything works fine except that on one table, in one database I am getting the error:

"#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"

The table was fin previously and I can access it from MySQL workstation OK.

Any ideas?

Neet
06-09-2011, 04:36 PM
The mysql socket file is missing from the /tmp directory?

If it is:

Edit the PhpMyAdmin configuration file to use the original MySQL socket file.

vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

Make sure, the correct mysql socket file is mentioned there.
~~~~~~~~~~~~~~~~
$cfg['Servers'][$i]['socket'] = ‘/var/lib/mysql/mysql.sock’;
$cfg['Servers'][$i]['connect_type'] = ‘socket’;
~~~~~~~~~~~~~~~~

Stooshie
06-09-2011, 05:50 PM
Thanks for that, however, I should have mentioned I am using xampp for windows.

Stooshie
06-09-2011, 06:01 PM
Actually, bizarrely, It has started working now, without having done anything.

The table had only about 2MB of data, but about half of that is indexes. Do you think it could have been indexing the table? Is that unlikely?

Thanks for your help anyway!

:-)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum