Menu
▾
▴
Re: [webmin-l] Mysql backup with charset definition
|
From: Jamie C. <jca...@we...> - 2006-04-12 20:48:38
|
Thanks! That is just what I needed ..<br /><br />=A0- Jamie<br /><br />On 12/Apr/2006 15:34 Jaime Ventura wrote .. <blockquote type=3D"cite"> <font size=3D"-1"><b /></font><br /> I think you can get that info on /usr/local/mysql/share/mysql/charsets .=A0 You may take a look on /usr/local/mysql/share/mysql/charsets/README file.<br /> This is the default location, which means it can be changed.<br /> 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'; "<br /> The the even greater part is that you can get supported charsets with a SQL query "show character set"; :P<br /> This works on mysql 4.x(<a href=3D"http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html" class=3D"moz-txt-link-freetext">http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html</a>) and=A0 mysql 5.x(<a href=3D"http://dev.mysql.com/doc/refman/5.0/en/show-character-set.html" class=3D"moz-txt-link-freetext">http://dev.mysql.com/doc/refman/5.0/en/show-character-set.html</a>) <br /> When using mysql 3.x., you will have to use=A0 the SQL query"show variables like 'character_sets';"<br /> <br /> -=A0=A0 Jaime<br /> <br /> Jamie Cameron wrote: <blockquote type=3D"cite" cite=3D"http://mail.webmin.com:20000/mailbox/mid...@ww..."> <pre>On 12/Apr/2006 12:35 Jaime Ventura wrote ..<br /> </pre> <blockquote type=3D"cite"> <pre>Hi,<br /> Is there any way to use the "backup database" feature on webmin's<br />mysql module and specify the "--default-character-set" option for mysqldump?<br /> If not, can i suggest that should be possible to specify such options?<br />Thanks<br /> </pre> </blockquote> <pre><!----> 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! <a href=3D"http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D121642" class=3D"moz-txt-link-freetext">http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D121642</a> - Forwarded by the Webmin mailing list at <a href=3D"_unsafe_link_" class=3D"moz-txt-link-abbreviated">web...@li...</a> To remove yourself from this list, go to <a href=3D"http://lists.sourceforge.net/lists/listinfo/webadmin-list" class=3D"moz-txt-link-freetext">http://lists.sourceforge.net/lists/listinfo/webadmin-list</a> </pre> </blockquote> </blockquote><br /> |
