http://tagfacts.com/kuchin/mysqlen-ushttp://tagfacts.com/kuchinInvision: drivers/mySQL.php

$this->query("SET NAMES 'cp1251'");
$this->query("SET CHARACTER_SET_CLIENT='cp1251'");

//$wpdb->query("SET CHARACTER_SET_CONNECTION='utf8'");
//$wpdb->query("SET CHARACTER_SET_RESULTS='utf8'");
//$wpdb->query("SET CHARACTER_SET_SERVER='utf8'");
//$wpdb->query("SET COLLATION_CONNECTION='utf8_general_ci'");
//$wpdb->query("SET COLLATION_SERVER='utf8_general_ci'");
by kuchin
Tags: charset mysql]]>Tue, 26 Dec 2006 10:02:31 GMTprograms_id_486kuchin@nosuchserver.comcharsetmysqlhttp://tagfacts.com/kuchinthen using diff -u, diff -u0, or maybe diff -e, between original mysqldump image and the new one to get the incremental.
by kuchin
Tags: backup mysql]]>Mon, 18 Dec 2006 12:29:47 GMTprograms_id_484kuchin@nosuchserver.combackupmysqlhttp://tagfacts.com/kuchinkey_buffer = 100M
#log-bin
max_connections = 100
by kuchin
Tags: mysql]]>Tue, 28 Feb 2006 20:53:41 GMTprograms_id_284kuchin@nosuchserver.commysqlhttp://tagfacts.com/kuchin
For old clients:
SET PASSWORD FOR some_user@'localhost' = OLD_PASSWORD('some_pass');
(link)
by kuchin
Tags: mysql setup]]>Mon, 19 Sep 2005 12:02:45 GMTprograms_id_22kuchin@nosuchserver.commysqlsetuphttp://tagfacts.com/kuchinzip -q -m SQL_`date +%F`.zip SQL_`date +%F`.sql
find www/ | zip Files_`date +%F`.zip -q -@
mv SQL_`date +%F`.zip www/mysql_dump/
mv Files_`date +%F`.zip www/mysql_dump/
by kuchin
Tags: backup mysql]]>Mon, 19 Sep 2005 11:18:27 GMTprograms_id_21kuchin@nosuchserver.combackupmysql