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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]