Hi Rick, ok sorry, heres a bit more detail, and I see some more useful stuff I didn't see before too (I still duno whats wrong but guess will be helpful to those more knowledgeable!).
I believe its using InnoDB for the tables, previously I was seeing an error 24 which from digging around can be related to too many open files, so I then tried with single transaction mode and get the successful backup exit status, but in verbose mode I see that there are obvious issues. mysqldump -v --single-transaction --socket=/usr/AdventNet/ME/OpManager/mysql/mysql.socket OpManagerDB -- Connecting to localhost... -- MySQL dump 10.11 -- -- Host: localhost Database: OpManagerDB -- ------------------------------------------------------ -- Server version 4.0.18-pro /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- Retrieving table structure for table ADGRAPHS... -- Skipping dump data for table 'ADGRAPHS', it has no fields -- Retrieving table structure for table ADMonitorRuleList... -- Skipping dump data for table 'ADMonitorRuleList', it has no fields -- Retrieving table structure for table ADServiceRuleList... -- Skipping dump data for table 'ADServiceRuleList', it has no fields -- Retrieving table structure for table ADServicesDefinition... -- Skipping dump data for table 'ADServicesDefinition', it has no fields -- Retrieving table structure for table ADWMIPolledData... -- Skipping dump data for table 'ADWMIPolledData', it has no fields ..... ..... -- Disconnecting from localhost... /*!40103 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40111 SET [EMAIL PROTECTED] */; -- Dump completed on 2008-10-30 19:06:25 Without single transaction I get this: mysqldump --socket=/usr/AdventNet/ME/OpManager/mysql/mysql.socket OpManagerDB -- MySQL dump 10.11 -- -- Host: localhost Database: OpManagerDB -- ------------------------------------------------------ -- Server version 4.0.18-pro /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; mysqldump: Got error: 1017: Can't find file: './OpManagerDB/WANIntfTypes.frm' (errno: 24) when using LOCK TABLES This file mentioned does exist in the location where all the datafiles for the OpManagerDB DB are stored: file WANIntfTypes.frm WANIntfTypes.frm: MySQL table definition file Version 7 Thanks, Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
