in reply to Re^3: DBI module not using new mysql.sock
in thread DBI module not using new mysql.sock

Thanks Alexander,
In a moment of paranoia I took out the I from my DB name forgetting that I already sent it.
I will try your DSN, but what I had before always worked - $dsn="DBI:mysql:SPT:localhost:3306";
I tried setting up the symlink as jmacloue suggested but I don't think I did it correctly. Linux is not my strong point and I've never set up a symlink. Seems like it should be easy but ...

Thanks for your help !

  • Comment on Re^4: DBI module not using new mysql.sock

Replies are listed 'Best First'.
Re^5: DBI module not using new mysql.sock
by afoken (Chancellor) on Feb 18, 2015 at 16:37 UTC
    I tried setting up the symlink as jmacloue suggested but I don't think I did it correctly. Linux is not my strong point and I've never set up a symlink. Seems like it should be easy but ...
    1. cd /where/the/symlink/should/be
    2. ln -s /target/of/symlink symlink-name

    In your case:

    1. cd /var/lib
    2. ln -s /data/mysql mysql

    After those two commands, you will find a symlink named mysql in the directory /var/lib, pointing to /data/mysql. For more details, read the fine manual: man ln

    Alexander

    --
    Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)