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



---------------------------------------------------------------------
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

Reply via email to