mysqlhotcopy "close of pipe failed" error with socket-copy.pl

[joudatfd]

Originally Posted by paddy

This is an issue with mysqlhotcopy. It cannot handle lot of tables. Please see comments in http://dev.mysql.com/doc/refman/5.1/...qlhotcopy.html See Jacob Rief's solution. You will have to modify ZRM code for this workaround.

Paddy

Hi,
thanks it works now, i was trying too increase file limit using "ulimit -n 10000" in script i used to simulate mysqhotcopty run.
But setting open_files_limit in my.cnf helped

Libor