Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder Stooshie's Avatar
    Join Date
    Mar 2008
    Location
    Dundee, Scotland
    Posts
    380
    Thanks
    9
    Thanked 39 Times in 39 Posts

    Question xampp upgrade causing error 2002 on 1 table only!

    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?
    Regards, Stooshie
    O

  • #2
    New to the CF scene
    Join Date
    Jun 2011
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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’;
    ~~~~~~~~~~~~~~~~

  • #3
    Regular Coder Stooshie's Avatar
    Join Date
    Mar 2008
    Location
    Dundee, Scotland
    Posts
    380
    Thanks
    9
    Thanked 39 Times in 39 Posts
    Thanks for that, however, I should have mentioned I am using xampp for windows.
    Regards, Stooshie
    O

  • #4
    Regular Coder Stooshie's Avatar
    Join Date
    Mar 2008
    Location
    Dundee, Scotland
    Posts
    380
    Thanks
    9
    Thanked 39 Times in 39 Posts
    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!

    :-)
    Regards, Stooshie
    O


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •