- 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 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=listsearcharchive@lassosoft.com
Apr 02
Claudio Nanni Re: Mysql Bug 04/01/11
Apr 02, 2011; 08:28
Claudio Nanni
Re: Mysql Bug 04/01/11
Apr 02
Jigal van Hemert Re: Mysql Bug 04/01/11
Apr 02, 2011; 08:44
Jigal van Hemert
Re: Mysql Bug 04/01/11
Apr 02
Reindl Harald Re: Mysql Bug 04/01/11
Apr 02, 2011; 12:45
Reindl Harald
Re: Mysql Bug 04/01/11
Apr 02
Claudio Nanni Re: Mysql Bug 04/01/11
Apr 02, 2011; 13:11
Claudio Nanni
Re: Mysql Bug 04/01/11
Apr 02
Reindl Harald Re: Mysql Bug 04/01/11
Apr 02, 2011; 13:28
Reindl Harald
Re: Mysql Bug 04/01/11
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!