I had a similar problem yesterday... Try launching mysqld like this:
`mysqld_safe --open-files-limit=8192`
If that works, you can make that the default in the my.cnf file.
Tim Donahue
On Wed, 16 Aug 2006 22:51:30 +0200
Julien TOUCHE <[EMAIL PROTECTED]> wrote:
>
> i'm testing mysql on openbsd 4.0 and have the the following problem:
>
> # mysqladmin -u root drop phpmyadmin
> Dropping the database is potentially a very bad thing to do.
> Any data stored in the database will be destroyed.
>
> Do you really want to drop the 'phpmyadmin' database [y/N] y
> mysqladmin: DROP DATABASE phpmyadmin failed;
> error: 'Can't find file: './mysql/proc.frm' (errno: 9)'
>
> # sudo -u _mysql mysqladmin drop phpmyadmin
> Dropping the database is potentially a very bad thing to do.
> Any data stored in the database will be destroyed.
>
> Do you really want to drop the 'phpmyadmin' database [y/N] y
> mysqladmin: DROP DATABASE phpmyadmin failed;
> error: 'Can't find file: './mysql/proc.frm' (errno: 9)'
> # ll mysql/proc*
> -rw-rw---- 1 _mysql _mysql 0 Aug 8 22:53 mysql/proc.MYD
> -rw-rw---- 1 _mysql _mysql 1024 Aug 8 22:53 mysql/proc.MYI
> -rw-rw---- 1 _mysql _mysql 9691 Aug 8 22:53 mysql/proc.frm
> -rw-rw---- 1 _mysql _mysql 0 Aug 8 22:53 mysql/
> procs_priv.MYD -rw-rw---- 1 _mysql _mysql 1024 Aug 8
> 22:53 mysql/ procs_priv.MYI -rw-rw---- 1 _mysql _mysql
> 8875 Aug 8 22:53 mysql/procs_priv.frm # mysql_secure_installation
> [...]
> Remove test database and access to it? [Y/n]
> - Dropping test database...
> ERROR 1017 (HY000) at line 1: Can't find file: './mysql/
> proc.frm' (errno: 9) ... Failed! Not critical, keep moving...
> - Removing privileges on test database...
> [...]
>
> has anyone the same problem ? solution ?
>
>
> thanks
> Regards
>
> Julien
>
> # pkg_info |grep mysql
> mysql-client-5.0.22 multithreaded SQL database (client)
> mysql-server-5.0.22 multithreaded SQL database (server)
> p5-DBD-mysql-3.0003 MySQL drivers for the Perl DBI
> php5-mysql-5.1.4 mysql database access extensions for php5
> # dmesg
> OpenBSD 4.0-beta (GENERIC) #1055: Thu Aug 3 11:39:24 MDT 2006
> [EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/GENERIC
> cpu0: Intel Pentium II ("GenuineIntel" 686-class, 512KB L2 cache) 351
> MHz [...]
>
