Web lists-archives.com

Re: MacOS Server 5 problem after upgrade

> Am 04.09.2016 um 23:35 schrieb Reindl Harald <h.reindl@xxxxxxxxxxxxx>:
> Am 04.09.2016 um 16:17 schrieb Matthias Schmidt:
>>> Am 04.09.2016 um 16:29 schrieb Reindl Harald <h.reindl@xxxxxxxxxxxxx>:
>>> Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:
>>>> 2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 - Operation not supported on socket)
>>>> 2016-09-04 15:25:19 85518 [ERROR] Can't start server: can't create PID file: Operation not supported on socket
>>>> the socket is created but then something goes wrong
>>> that sounds like socket and pid are configured for the same location
>>> what about "rm -f /usr/local/mysql/data/mysqld.local.pid" and show us your config
>> thanks, that did the trick and made it run, but now I just discovered that my databases are all gone …
>> Of course I have backups, but really no experience how to get the stuff back :(
> just configure “datadir” to the correct location and get familar with mysql basics and your operating system

there have been 2 problems:
- the last mysql update didn’t do the update and the data folder didn’t contain the databases :-0
- the sock file was created in the temp folder instead of the var folder, after setting the sock file to the var/mysql folder all works fine

besides the control panel, it “thinks" the server is not running, although it is, so I guess I can delete it, as it is also not anymore distributed with the current versions for OS10.11

so, thanks especially to Harald, much appreciated :-)

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail