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

[Pat E. <mai...@pa...>]

thanks, worked.. there are a lot of small differences in the 4.x tree,  
especially when importing/exporting with mysqldump you almost always have  
to set the "–compat=" switch. so maybe it's a good idea to offer some  
sensible values there..

PAT

On Tue, 27 Jun 2006 19:16:30 +0200, Jamie Cameron <jca...@we...>  
wrote:

> 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
>
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job  
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> -
> Forwarded by the Webmin mailing list at  
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list