From: Dan Nelson
Date: June 5 2002 2:54pm
Subject: Re: mysqlhotcopy regexp problem with 640 and more Databases
List-Archive: http://lists.mysql.com/mysql/111055
Message-Id: <20020605145404.GE11978@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jun 05), Pabst Simon said:
> Description:
> 
> When using mysqlhotcopy 1.15 for database backups with --regexp='.*' and
> having 640 or more Databases produces the following error:
>  
> DBD::mysql::db do failed: File '/lvol1/mysql/data/mydatabase/mytable640.MYD' not found (Errcode: 24) at ./bin/mysqlhotcopy line 432.

And did you run "perror 24" to find out why the OS wouldn't let mysql
open the file?

$ perror 24
Error code  24:  Too many open files
$ 

Make sure the OS is configured to let mysql open lots and lots of files
at once.

-- 
	Dan Nelson
	dnelson@stripped