Bug #30303 While trying to dump all databases shows error
Submitted: 8 Aug 2007 13:22 Modified: 10 Aug 2007 7:49
Reporter: Sebastian Vaisov Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Backup Severity:S2 (Serious)
Version:5.0.32 OS:Linux (Debian gcc version 2.95.4 20011002)
Assigned to: CPU Architecture:Any
Tags: Backup, mysqldump, query

[8 Aug 2007 13:22] Sebastian Vaisov 
Description:
When trying to use mysqldump --alldatabases > file.sql it returns error: mysqldump: Couldn't execute '/*!40100 SET @@SQL_MODE='' */': Query was empty (1065)

How to repeat:
mysqldump --alldatabases > file.sql
[8 Aug 2007 22:36] Sveta Smirnova 
Thank you for the report.

Version 5.0.32 is quite old. Additionally I can not repeat described behaviour with current development sources. Please upgrade to current version 5.0.45, try with it and say us result.

Also you indicated version of gcc. If you compiled sources yourself and can repeat the problem with 5.0.45, provide exact configure string.
[9 Aug 2007 10:51] Sebastian Vaisov 
It looks like i had 2 mysqlds on system, running mysqldump from /usr/local/mysql/bin helped.
[10 Aug 2007 7:49] Sveta Smirnova 
Thank you for the feedback.

According to last comment I'll close the report as "Can't repeat".