From: SDiZ Cheng
Date: June 15 2001 3:55am
Subject: mysqldump on large database..
List-Archive: http://lists.mysql.com/mysql/76655
Message-Id: <006f01c0f54f$0890c220$0300a8c0@linux>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="big5"
Content-Transfer-Encoding: 7bit

When i use mysqldump, 
seems that MySQL will open all the tables in the database.
But, what i have is: a database will over 10,000 tables ..
I get a "Too much opened file" error on this..
I think increasing open_file_limit is not possible,
because of the limit of the OS itself..

Can anyone suggest an alternative for mysqldump?

--
Cheng Yuk Pong (SDiZ) 
4096/1024 DH/DSS   0xA4C6FAD3
FE28 E6D4 AD21 5D4F F07B  EEA6 3C88 5DBB A4C6 FAD3