Bug #11501 mysqldump can't get info about tables from older server
Submitted: 22 Jun 2005 13:16 Modified: 22 Jun 2005 14:46
Reporter: Andy Speagle Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:v9.11 distrib 4.0.24 OS:Linux (Linux (Debian Sarge))
Assigned to: CPU Architecture:Any

[22 Jun 2005 13:16] Andy Speagle 
Description:
When attempting to connect to a remote mysql server v3.22.32 via mysqldump v9.11 Distrib 4.0.24 it cannot get info about tables on the target server.  Below is the output of a simple dump

eonrptsvr:/var/www/mrtg# mysqldump -t -h 192.168.10.20 -u ROOT -w "startdate='2005-06-20'" abk swku
-- MySQL dump 9.11
--
-- Host: 192.168.10.20    Database: abk
-- ------------------------------------------------------
-- Server version       3.22.32
mysqldump: Can't get info about table: `swku`
error: You have an error in your SQL syntax near '`swku`' at line 1

How to repeat:
Any attempts to dump databases from the remote v3.22.32 server fail due to the inability to read the table information, such as:

eonrptsvr:/var/www/mrtg# mysqldump -t -h 192.168.10.20 -u ROOT abk
-- MySQL dump 9.11
--
-- Host: 192.168.10.20    Database: abk
-- ------------------------------------------------------
-- Server version       3.22.32
mysqldump: Can't get info about table: `agact`
error: You have an error in your SQL syntax near '`agact`' at line 1
[22 Jun 2005 14:46] MySQL Verification Team 
Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.