Gentlemen:

- Keep in mind that I have approximately 50 hours into this Mysql server install and still no
results!

- Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz

- When installed and started with the following command:
/usr/local/mysql/bin/mysqld_safe --user=mysql &

The following error occurs:
110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)

1) Please identify where the missing file can be found, keeping in mind that I just installed and
have no backup (of the current rev.).

2) If we are installing in /usr/local/mysql where exactly dose this file belong,
(exact path please).

3) What exactly do the file ownersiip and permissions have to be?

Keep in mind that I have tried several dozen experiments over many late hours with a version host.frm from a older version of mysql with NO success! I have tried putting
it in every possible location. Using 777 file permissions.

A snapshot of my system:
root@Sun# pwd
/usr/local/mysql
root@Sun# ls
bin         info        man         mysql-test  var
host.frm    lib         my.cnf      share
include     libexec     mysql       sql-bench

root@Sun# ls -la host.frm
-rwxrwxrwx   1 root     root        9064 Apr  1 16:39 host.frm

root@Sun# ls -la mysql
total 22
drwxrwxrwx   2 root     root         512 Apr  1 16:34 .
drwxr-xr-x  13 bin      bin          512 Apr  1 16:39 ..
-rwxrwxrwx   1 root     root        9064 Apr  1 16:34 host.frm

- The entire transcript is shown below:

10401 16:39:27  mysqld started
110401 16:39:27 [Warning] option 'max_join_size': unsigned value 18446744073709
551615 adjusted to 4294967295
110401 16:39:27 [Warning] option 'max_join_size': unsigned value 18446744073709
551615 adjusted to 4294967295
110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 adjusted
to 131072
110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 adjusted
to 131072
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110401 16:39:27  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...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
110401 16:39:27 InnoDB: Starting an apply batch of log records to the database
...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 5 1 52 53 54 55 56 57 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 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
110401 16:39:27  InnoDB: Started; log sequence number 0 43655
110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my
sql/host.frm' (errno: 13)
110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my
sql/host.frm' (errno: 13)
110401 16:39:27 [ERROR] Fatal error: Can't open and lock privilege tables: Can'
t find file: './mysql/host.frm' (errno: 13)
110401 16:39:27  mysqld ended

110401 16:42:30  mysqld started
110401 16:42:30 [Warning] option 'max_join_size': unsigned value 18446744073709
551615 adjusted to 4294967295
110401 16:42:30 [Warning] option 'max_join_size': unsigned value 18446744073709
551615 adjusted to 4294967295
110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 adjusted
to 131072
110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 adjusted
to 131072
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110401 16:42:30  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...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
110401 16:42:30 InnoDB: Starting an apply batch of log records to the database
...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 5 1 52 53 54 55 56 57 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 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
110401 16:42:30  InnoDB: Started; log sequence number 0 43655
110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my
sql/host.frm' (errno: 13)
110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my
sql/host.frm' (errno: 13)
110401 16:42:30 [ERROR] Fatal error: Can't open and lock privilege tables: Can'
t find file: './mysql/host.frm' (errno: 13)
110401 16:42:30  mysqld ended

root@Sun#

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to