what command are you using to do the dump? I mean the entire command, including all the options.
On Thu, Oct 30, 2008 at 12:25 PM, Andy Smith <[EMAIL PROTECTED]> wrote: > Hi, > > Im having an issue using mysqldump to dump a DB from comercial app which > includes mysql 4.0.18-pro. It doesnt however include mysql dump for online > backups so Im using the one installed by default in my linux dist which as > you can see below is version 10.11. My problem is that the dump is exiting > with exist status 0 but Im not getting any of the data dumped. The WHOLE > dump is shown in text below: > > -- 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 */; > /*!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-27 13:50:53 > > Can anyone help me? I need to work out why no data is written, > > thanks Andy. > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
