Wow! What kind of database would have 10,000 tables? Wouldn't you think
the database design had a serious flaw in the first place?
SDiZ Cheng wrote:
>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