TagFacts

WordPress: wp-db.php
Invision: 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'");

mysqldump --extended-insert=false
then using diff -u, diff -u0, or maybe diff -e, between original mysqldump image and the new one to get the incremental.

[mysqld]
key_buffer = 100M
#log-bin
max_connections = 100

GRANT ALL PRIVILEGES ON dbname.* TO some_user@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

For old clients:
SET PASSWORD FOR some_user@'localhost' = OLD_PASSWORD('some_pass');

mysqldump -q -A -hlocalhost -uuser -ppassword > SQL_`date +%F`.sql
zip -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/