Hi Daniel,
Check your permissions. Your mysqld process is probably trying to create
the log file but can't and is telling you via the error code 13 message
$ perror 13
System error: 13 = Permission denied
$
Regards
Daniel C. Mahoney wrote:
I'm running MySQL (--ersion says "mysql Ver 14.7 Distrib 4.1.10a, for
pc-linux-gnu (i686)) on a RedHat Enterprise ES Release 4 system. The
datadir was in it's own filesystem, mounted at /mysql, but it's now
filled up (it's a 15 GB partition and it has 1.5 MB free).
I shut down MySQL (did a "kill `cat /mysql/mysql.pid` and waited for
the daemon to exit), created a new directory (/z/mysql, in a
filesystem with about 30 GB free), and verified that the files copied ok.
I now try to restart mysql with "/usr/local/bin/mysqld_safe
--datadir=/z/mysql --pid-file=/z/mysql/mysql.pid > /dev/null 2>&1 &".
When I do a "ps ax" afterwards I don't see mysqld running. The host
name is www2, so I looked in /z/mysql/www2.err and saw:
051107 00:32:49 mysqld started
/usr/local/libexec/mysqld: File './www2-bin.000046' not found
(Errcode: 13)
051107 0:32:49 [ERROR] Could not use www2-bin for logging (error 13).
Turning logging off for the whole duration of the MySQL server
process. To turn it on again: fix the cause, shutdown the MySQL server
and restart it.
051107 0:32:49 [ERROR] Aborting
051107 0:32:49 [Note] /usr/local/libexec/mysqld: Shutdown complete
051107 00:32:49 mysqld ended
This confuses the crap out of me! I looked again in the /mysql
directory, and there is no file named www2-bin.000046 prewent. There
is a www2-bin.000045, and that same file is present in /z mysql and is
the same size.
So why is mysql looking for that non-existent file? And what do I have
to do to make this work again? This is kind of a critical problem for us.
--------------------------
Dan Mahoney
[EMAIL PROTECTED]
"How you behave towards cats here below determines your status in
Heaven."
Robert Heinlein
"There are two means of refuge from the miseries of
life - music and cats" - Albert Schweitzer
--
David Logan
South Australia
when in trouble, or in doubt
run in circles, scream and shout
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
