On Tue, 2002-03-26 at 07:24, Hans Kind wrote: > Dear Martin, > > I tried that option, but it returns a errono 24: > > ../bin/mysqlhotcopy -u username -p password --flushlog --allowold > --regexp='.*' /d1/terminal-a/mysql/ > 'mail' is an empty database > 'opt' is an empty database > 'oveas' is an empty database > DBD::mysql::db do failed: Can't find file: > './alternat/nuke_bannerfinish.frm' (errno: 24) at ../bin/mysqlhotcopy line 434. > > It creates the directories, but doesn't backup any of the tables. > > In the archives I found similar reports, but it was mentioned the problem > was fixed!. > > Not sure how this errono 24 (Error code 24: Too many open files) relates > to this problem. > [snip]
Maybe there are too many open files. How many tables are there in the set of databases you're trying to back up ? I think the error is being thrown when attempting to lock all the tables before the copy. I don't know how mysql locks tables, but if it use flock (or equivalent) that may open one or more files per table. If you have several thousand tables - that may exceed you OS limits. What gets displayed when you run mysqlhotcopy with the '--debug' ( and maybe the '--dryrun' ) flags ? regards, Martin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
