From: Otto Moerbeek (ottodrijf.net)
Date: Sun Jan 09 2005 - 13:30:25 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Sun, 9 Jan 2005, Cameron Schaus wrote:

> I installed the 3.6 mysql packages onto a 3.6 stable machine (i386).
> I copied the databases from my 3.4 machine into /var/mysql. mysql
> worked fine for some databases, but for others it would not work.
>
> Trying to do a mysqldump gives:
> mysqldump: Can't get CREATE TABLE for table `[table]` (File
> './[database]/[table].MYD' not found (Errcode: 9))
>
> There are no errors in the logs. I also see that someone else
> reported this problem:
> http://www.monkey.org/openbsd/archive/misc/0410/msg02610.html
>
> Following the advice in the post above I checked out the 3.5 mysql
> port from cvs and compiled and installed it. Things are running fine
> now, as I can access the database that was previously inaccessable and
> I can now dump the database.
>
> Is the problem with the mysql port fixed in current?

The problem disappears if you start the 3.6 port with
mysqld_safe--open-files=1000

There's also a corresponding option you can set in the config file.

        -Otto

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]