mysqlhotcopy -- max number of tables

2004-03-31 Thread Andrew Loughe
The mysqlhotcopy perl script is failing fail when I try to back up
a database containing more than about 600 tables.  The script appears
to be unable to lock that many tables before making the actual copy.
Have others experienced this same problem?

Is this a limitation of DBI, or of MySQL 3.23.58?

Is there a known work-around?

Thanks for any help!

[  MySQL 3.23.58 , MyISAM tables, RH linux  ]

--
Andrew Loughe =
NOAA/OAR/FSL/AD   R/FS5  |  email: [EMAIL PROTECTED]
325 Broadway |  wwweb: www-ad.fsl.noaa.gov/users/loughe
Boulder, CO  80305-3328  |  phone: 303-497-6211   fax: 303-497-6301


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


RE: mysqlhotcopy -- max number of tables

2004-03-31 Thread Dathan Vance Pattishall
Can you send the error message? It might be a timeout problem which is a
mySQL configuration issue. (Look at wait_timeout in my.cnf)


 -Original Message-
 From: Andrew Loughe [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, March 31, 2004 10:30 AM
 To: [EMAIL PROTECTED]
 Subject: mysqlhotcopy -- max number of tables
 
 The mysqlhotcopy perl script is failing fail when I try to back up
 a database containing more than about 600 tables.  The script appears
 to be unable to lock that many tables before making the actual copy.
 
 Have others experienced this same problem?
 
 Is this a limitation of DBI, or of MySQL 3.23.58?
 
 Is there a known work-around?
 
 Thanks for any help!
 
 
 [  MySQL 3.23.58 , MyISAM tables, RH linux  ]
 
 
 --
 Andrew Loughe =
 NOAA/OAR/FSL/AD   R/FS5  |  email: [EMAIL PROTECTED]
 325 Broadway |  wwweb: www-ad.fsl.noaa.gov/users/loughe
 Boulder, CO  80305-3328  |  phone: 303-497-6211   fax: 303-497-6301
 
 
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]