Hello:
The saga of this machine continues:
FreeBSD v6.2
latest mysql version installed from ports:
mysql51 client, serve, and scripts.
There is no /usr/local/mysql
it did not create this dir.
the following errors are encountered when
attempting to run the server:
071121 15:04:37 mysqld started
071121 15:04:37 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
071121 15:04:37 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 39542.
InnoDB: Doing recovery: scanned up to log sequence number 0 46403
071121 15:04:37 InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
19 20 21 22 23 24 25 26 27 28 29 30 31 (wrapped for this message)
32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
56 57 (wrapped for this message)
58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
82 83 (wrapped for this message)
84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
071121 15:04:38 InnoDB: Started; log sequence number 0 46403
/usr/local/libexec/mysqld: Can't find file: './mysql/general_log.frm'
(errno: 13)
071121 15:04:38 [ERROR] /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
071121 15:04:38 [ERROR] Fatal error: Can't open and lock privilege
tables: Can't find file: './mysql/host.frm' (errno: 13)
071121 15:04:38 mysqld ended
where is './mysql/ (etc)? the ./ tells me it is relative to
/usr/local/libexec
I have followed the published instruction steps to configure build and
install
from source dist and it specifies that data dir should be change to
owner mysql
but where is the data dir. It is not in /var, unless it is supposed to
be in /var/db
(where I found the hostname error file). Errno: 13 means access denied
as I
understand it. So what dir and files do I change privileges for, if
that is in fact,
the problem?
I have had this machine for over a year and have not gotten mysql to
run on it
at all. I have mysql installed and running on 6 other machines, three
of which
are FreeBSD 6.0 and 6.2 (others, Debian Etch, Mac OSX)
This is AMD64 on Gigabyte motherboard: FreeBSD is Generic kernel
(I am not an enterprise. I am a hobbyist at present. If and when I get
some income from this I will share it with the sources of free software
I use)
Thanks in advance;
Jeff K
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]