MySQL Bugs: #36482: mysqldump Dist 5.0.54 fail silently when trying to dump from 4.0.27 server

Bug #36482	mysqldump Dist 5.0.54 fail silently when trying to dump from 4.0.27 server
Submitted:	2 May 2008 23:20	Modified:	7 May 2008 15:46
Reporter:	Till Korten	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Backup	Severity:	S2 (Serious)
Version:	5.0.54	OS:	Linux (gentoo x86 kernel 2.6.20)
Assigned to:		CPU Architecture:	Any

Description:
trying to dump a database from a remote 4.0.27 server using mysqldump 10.11 Dist 5.0.54 fails silently returning no actual database data, only some comments:

command: mysqldump --host=remote_host -p -u username database_name

output:
-- MySQL dump 10.11
--
-- Host: sql16.your-server.de    Database: soleel_typo3
-- ------------------------------------------------------
-- Server version       4.0.27-standard
/*!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 TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-05-02 14:33:13

at the empty line after /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; the output halts for about 1 min (approximately the time a working mysqldump takes), then the rest of the ouptut is returned.

expected behavior: dump whole database

I had the same problem with mysqldump  Ver 10.11 Distrib 5.0.51a, for apple-darwin8.5.1 (i686).

The same mysqldump command works as expected with mysqldump  Ver 10.11 Distrib 5.0.38, for pc-linux-gnu (i686) (and server Version 4.0.27)

I havent tried any other mysql versions yet.

I don't have any influence on the remote database (shared hosting system). so I do not know any details about its configuation

How to repeat:
set up a remote database called database_name with mysql version 4.0.27
install mysql 5.0.54 on a client system
run: mysqldump --host=remote_host -p -u username database_name
enter correct password

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of bug #34192

Sorry for this. When searching for bugs describing this issue, I only searched active bugs, therefore I missed bug #34192.

Thank you for pointing that out to me. I'll just wait till 5.0.60 becomes available in my distro...