- 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
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