[Bug 267696] [NEW] mysqldump fails silently against mysql 4.0 server

[Liam Bedford]

Public bug reported:

This affects the version of mysql-dfsg-5.0 in hardy. Intrepid is up to date enough to
work correctly.

Upstream bug:
http://bugs.mysql.com/bug.php?id=34192

[copied and reworded a little from the upstream bug]
mysqldump in 5.0.51 SILENTLY fails to dump databases from mysql 4.0 server.

The dump of any 4.0 database is missing the data. 
It's because now mysqldump unconditionally runs (client/mysqldump.c):

      my_snprintf(buff, sizeof(buff), "show create table %s",
result_table);

      if (switch_character_set_results(mysql, "binary") ||
          mysql_query_with_error_report(mysql, &result, buff) ||
          switch_character_set_results(mysql, default_charset))             
                 DBUG_RETURN(0);

where switch_character_set_results() are not supported on mysql < 4.1

** Affects: mysql-dfsg-5.0 (Ubuntu)
     Importance: Undecided
         Status: New

** Description changed:

+ This affects the version of mysql-dfsg-5.0 in hardy. Intrepid is up to date enough to
+ work correctly.
+ 
  Upstream bug:
  http://bugs.mysql.com/bug.php?id=34192
  
  [copied and reworded a little from the upstream bug]
  mysqldump in 5.0.51 SILENTLY fails to dump databases from mysql 4.0 server.
  
  The dump of any 4.0 database is missing the data. 
  It's because now mysqldump unconditionally runs (client/mysqldump.c):
  
        my_snprintf(buff, sizeof(buff), "show create table %s",
  result_table);
  
        if (switch_character_set_results(mysql, "binary") ||
            mysql_query_with_error_report(mysql, &result, buff) ||
            switch_character_set_results(mysql, default_charset))             
                   DBUG_RETURN(0);
  
  where switch_character_set_results() are not supported on mysql < 4.1

-- 
mysqldump fails silently against mysql 4.0 server
https://bugs.launchpad.net/bugs/267696
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.