Yes.. I know.. But that's not my design.
That will be change in a few month..
My job now is: dump all of them out.
----- Original Message -----
> 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?
>
> Seung-woo Nam
>
> 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
> >
> >
> >
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
---------------------------------------------------------------------
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