I had the default installations of php mysql and apache but changed it around to use xampp. Main reason being having everything in the one folder so it could all be backed up as one, and also for rsynking between machines.
But I hit a problem. I used the package manager to remove the server and db then downloaded and installed Xampp. The install went fine and i was up and running in next to no time. The problem came when i tried to import my largest SQL file.
Its 400+ meg so there was no way phpMyAdmin would be able to handle it. I went into shell and when I try from there it gives the following error...
root@mack-desktop:/opt/lampp/bin# mysql -uroot -ppassword -h localhost uk < /home/mack/Documents/Websites/example/data/datafile.sql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
It seams as if mysql client is still trying to reference the old install.
Can this be altered in a config file?