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