mysqldump locks dumping db mysql in 5.1.9
Hello, I've got 5.1.9 running on FreeBSD and I'm trying to do some backups, but mysqldump is locking up on me. when I run: mysqldump -uroot --opt mysql (and yes, it's a test box, so there is no root password. I can duplicate this behavior with other accounts with sufficient priv's specifying a password) I get: -- MySQL dump 10.10 -- -- Host: localhostDatabase: mysql -- -- -- Server version 5.1.9-beta /*!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 */; /*!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 */; and then it just freezes there till I ctl+c out. It should be noted that I can dump all other db's just fine. This version was installed using ports. mysqldump -V returns: mysqldump Ver 10.10 Distrib 5.1.6-alpha, for portbld-freebsd6.1 (i386) which appears to be 0.0.3 versions out of date compared to the server. Was there some change in DB structure that might cause this issue? Other suggestions? Is this a legit bug I should report to the buglist or did I screw something up? Thanks :) -- James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump locks dumping db mysql in 5.1.9
On Wednesday, 7 June 2006 at 11:35:56 -0700, James Barros wrote: Hello, I've got 5.1.9 running on FreeBSD and I'm trying to do some backups, but mysqldump is locking up on me. when I run: mysqldump -uroot --opt mysql (and yes, it's a test box, so there is no root password. I can duplicate this behavior with other accounts with sufficient priv's specifying a password) I get: /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; and then it just freezes there till I ctl+c out. Is this a legit bug I should report to the buglist or did I screw something up? mysqldump should not hang, so it's a bug. The real question is how you managed to trip it. Please enter a bug report and I'll look at it as soon as possible. Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia Phone: +61-8-8388-8286 Mobile: +61-418-838-708 VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED] Are you MySQL certified? http://www.mysql.com/certification/ pgprqsw4l2kvI.pgp Description: PGP signature