The problem with mysqldump utility

The problem with mysqldump utility

am 05.03.2005 06:03:13 von poxuxol

I'm new to MySQL and I have a simple test database, named 'test'. My
MySQL runs on Windows 2000 system. I want to backup my database using
mysqldump utility by command:
> mysqldump -u root -p --opt test > logfile

and see the message:
"mysqldump: mysqldump: Couldn't execute 'show fields from
`customer_tbl`': Lost connection to MySQL server during query (2013)"

logfile contents:
-- MySQL dump 10.9
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 5.0.2-alpha-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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" */;

--
-- Table structure for table `customer_tbl`
--

DROP TABLE IF EXISTS `customer_tbl`;
CREATE TABLE `customer_tbl` (
`cust_id` varchar(10) NOT NULL,
`cust_name` varchar(30) NOT NULL,
`cust_address` varchar(20) NOT NULL,
`cust_city` varchar(15) NOT NULL,
`cust_state` char(2) NOT NULL,
`cust_zip` decimal(5,0) NOT NULL,
`cust_phone` decimal(10,0) default NULL,
`cust_fax` decimal(10,0) default NULL,
PRIMARY KEY (`cust_id`)
) ENGINE=MyISAM DEFAULT CHARSET=koi8r;

After that MySQL service stops and I must start it again.

What can I do?

Oleg

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org