Can't create file could be caused by not having enough free space left. Easy to check .
I think I remember I got a different err number in a simular situation..
You did check permissions.. right?
B.
At 15:32 23-03-2003 +0000, Phil Dobbin wrote:
On 23/3/03 15:27, "Stefan Siefert" <[EMAIL PROTECTED]> wrote:
> Hi Phil, > > ok, just to make sure your mysqld isn't damaged, what about replacing it > with a new one (just binaries, not config and data)?
Sounds a good idea but I'm unsure how to go about it. Would you know the best possible way?
Regards,
Phil.
> -----Ursprungliche Nachricht-----
> Von: Phil Dobbin [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 23. Marz 2003 16:21
> An: Stefan Siefert; MySQL
> Betreff: Re: AW: Mysqld problem
>
>
> On 23/3/03 13:31, "Stefan Siefert" <[EMAIL PROTECTED]> wrote:
>
>> Hi Phil,
>>
>> first of all I don't think your mysqld is damaged. I would first check the
>> following:
>>
>> - where does mysqld looks for its datadir?
>> - under which userid is mysqld supposed to run?
>> - under which userid does mysqld runs?
>> - does the user under which mysqld runs have write access to the datadir
>> directory?
>> - is the mysql database installed in the datadir directory?
>
> Hi, Stefan.
>
> All things mysql are in their correct place (this has only just happened and
> I haven't changed anything in any directory pertaining to mysql).
>
> I basically cannot get mysqld to start in any shape or form, either from its
> system boot startup script or manually.
>
> Regards,
>
> Phil.
>
>
>>
>> -----Ursprungliche Nachricht-----
>> Von: Phil Dobbin [mailto:[EMAIL PROTECTED]
>> Gesendet: Sonntag, 23. Marz 2003 14:09
>> An: MySQL
>> Betreff: Mysqld problem
>>
>>
>> I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X
>> 10.1.5 and have a startup script which confirms on boot that it has
> started
>> but doesn't.
>>
>> I've tried starting manually from the CLI but no luck. I looked in
>> localhost.err and found:
>>
>> 030323 9:48:21 /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write
> to
>> file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
>> 030323 9:48:22 /usr/local/mysql-3.23.51/bin/mysqld: Can't find file:
>> './mysql/host.frm' (errno: 13)
>> 030323 9:48:22 /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of
>> '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13)
>> 030323 09:48:22 mysqld ended
>>
>> According to the O'Reilly `MySQL Reference Manual' it seems that the
> daemon
>> may have been damaged but offers no real clue as how to fix it.
>>
>> One other very odd aspect is that on OS X you create a mysql user in Sys
>> Prefs and I noticed, upon reboot, that this user had disappeared from the
>> pref panel. I re-created but to no avail.
>>
>> Any help at all on this would be gratefully appreciated.
>>
>> Regards,
>>
>> Phil.
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/[EMAIL PROTECTED]
>>
>>
>
>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
