Re: [webmin-l] Mysql backup with charset definition

[Jaime V. <jai...@ip...>]

**
I think you can get that info on /usr/local/mysql/share/mysql/charsets 
.  You may take a look on /usr/local/mysql/share/mysql/charsets/README file.
This is the default location, which means it can be changed.
The good part is that you can get the location of the fileset config 
directory by doing the SQL query "show variables like 
'character_sets_dir'; "
The the even greater part is that you can get supported charsets with a 
SQL query "show character set"; :P
This works on mysql 
4.x(http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html) 
and  mysql 
5.x(http://dev.mysql.com/doc/refman/5.0/en/show-character-set.html)
When using mysql 3.x., you will have to use  the SQL query"show 
variables like 'character_sets';"

-   Jaime

Jamie Cameron wrote:
> On 12/Apr/2006 12:35 Jaime Ventura wrote ..
>   
>> Hi,
>>     Is there any way to use the "backup database"  feature on webmin's
>> mysql module and specify the "--default-character-set" option for mysqldump?
>>     If not, can i suggest that should be possible to specify such options?
>> Thanks
>>     
>
> There is no way to do this at the moment, but it is a good idea .. I will add
> an option for this to the next Webmin release.
>
> Do you know of any way to get a list of possible character sets though?
>
>  - Jamie
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&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
>
>