Re: [webmin-l] [BUG] mysql backup broken since 1.280 (?)

[Jamie C. <jca...@we...>]

On 27/Jun/2006 02:01 Pat Erler wrote ..
> hi,
> 
> since 1.280, when i try to backup a whole database (mysql database|select
> db|button "backup database") i get:
> 
> "SQL show character set failed : You have an error in your SQL syntax.
> Check the manual that corresponds to your MySQL server version for the
> right syntax to use near 'character set' at line 1"
> 
> all this on debian 3.1, mysql  Ver 12.22 Distrib 4.0.24, for pc-linux-gnu
> (i386)

This looks like a bug in Webmin - it currently assumes that mysql 4.0 supports
the 'show character' set command, but I am guessing that only 4.1 does. You
can fix this by editing the file mysql/mysql-lib.pl under the Webmin root, and
changing line 988 to :

if ($mysql_version < 4.1) {

 - Jamie