Craig Cummings wrote:
>
> Hi there,
>
> Immediately after installing MySQL (RPM), I mounted a separate
> disk partition on /var/lib/mysql to accomodate a large database. Prior to
> doing this, I temporarily moved the contents of that directory. I then
> moved them back after remounting. Somewhere in the process, I lost
> mysql.sock. Of course, I can't start the MySQL daemon now. Can you
> explain how to get the situation back to normal? Thank you very much.
>
Craig:
Please note that this list is for reporting bugs when you have a fully
functional test case that demonstrates the problem. If you need help with MySQL,
you should write to mysql@stripped if you have not purchased support or
support@stripped if you have.
Mounting a new volume onto the directory containing the socket file (
/var/lib/mysql/) will make all previously existing files, including the socket
file unavailable, and socket file cannot just be copied, because it is not a
regular file. You need to shut mysqld down ( killall mysqld), and then restart
it for the socket file to be properly created in the new directory.
--
Sasha Pachev
+------------------------------------------------------------------+
| ____ __ _____ _____ ___ http://www.mysql.com |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
| Thread |
|---|
| • no mysql.sock | Craig Cummings | 12 Aug |
| • Re: no mysql.sock | sasha | 12 Aug |
