On Wed, 2003-07-30 at 17:40, Vladimir Shiray wrote: > > How can I make hotcopy of my database if it have many tables (more than 1000) ??? > mysqlhotcopy failed when it try to lock all tables ... > > How many tables can I lock at one time ? > Can I increase this limit ? > Hi,
You probably ran out of file handles. The available file handles can be increased by modifying the table_cache and max_connections variables in my.cnf, eg. set-variable = table_cache=3000 You might need to tinker with /proc/sys/fs/file-max if you hit your operating system's hard limit. regards, Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
