- Original Message -
In the last episode (Jun 15), SDiZ Cheng said:
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
In the last episode (Jun 15), SDiZ Cheng said:
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,
Hello
I created a perl script that might help. Because I like to have a full backup
of my databases and table backups (I know I can split the full backup, but
I'm too lazy ;), I created a perl script that queries MySQL for the table
names in the database and then creates a shell script with
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
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
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