List:General Discussion« Previous MessageNext Message »
From:SDiZ Cheng Date:June 15 2001 3:55am
Subject:mysqldump on large database..
View as plain text  
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


Thread
mysqldump on large database..SDiZ Cheng15 Jun
  • Re: mysqldump on large database..Seung-woo Nam15 Jun
  • Re: mysqldump on large database..SDiZ Cheng15 Jun
  • Re: mysqldump on large database..Dan Nelson15 Jun
    • Re: mysqldump on large database..John Cichy15 Jun
  • Re: mysqldump on large database..SDiZ Cheng16 Jun