Re: MacOS Server 5 problem after upgrade

Matthias Schmidt <[email protected]> Thu, 8 Sep 2016 17:25:54 +0900

Newsgroups	gmane.comp.db.mysql.general
Message-ID	<[email protected]>

> Am 04.09.2016 um 23:35 schrieb Reindl Harald <[email protected]>:
> 
> 
> 
> Am 04.09.2016 um 16:17 schrieb Matthias Schmidt:
>>> Am 04.09.2016 um 16:29 schrieb Reindl Harald <[email protected]>:
>>> 
>>> 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 :-)
Matthias

signature.asc (application/pgp-signature, 495 B)