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