Thanks for the idea - I had a look for mysql.sock, but it was already
gone (I think the startup script must have deleted it)
For the record, to get mysqld to start again we had to run the startup
command from the mysql user account. The linux startup script runs as
root, it calls safe_mysqld, which uses the option --user=mysql, but
that's not enough, you must actually *be* the user mysql for startup to
work properly, at least on this particular system.
Gerald Clark wrote:
> Did you try deleting the mysql.sock before starting the server?
> fsck seems to have changed its file type.
>
> Katrina Maffey wrote:
>
>> Description:
>>
>> After a brief power failure, I rebooted the mysql server machine,
>> and got this error on startup:
>>
>> Starting mysqld daemon with databases from /var/lib/mysql
>> /usr/bin/safe_mysqld: line 254: 1844 Segmentation fault (core
>> dumped) $NOHUP_NICENESS $ledir/$MYSQLD $defaults
>> --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION
>> --pid-file=$pid_file --skip-locking >>$err_log 2>&1
>> 010910 13:32:48 mysqld ended
>>
>> I tried running myisamchk -re on every *.MYI file under
>> /var/lib/mysql, and they seemed to repair successfully, however the
>> crash still occurs. From the strace output, I don't think mysqld
>> even gets as far as opening these files. What else can I try to get
>> mysqld running again?
>>
>>> >Extra info:
>>
>>
>>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
