mysqltunner script

Useful for /etc/my.cnf tunning of mysql

PHP & MySQL 5 中文字亂碼

Try to specify the character set to utf8. Unlike MySQL 4 which use Latin1 as the default character set, MySQL 5 use utf8

mysql_query(‘SET NAMES utf8’); mysql_query(‘SET CHARACTER_SET_CLIENT=utf8’); mysql_query(‘SET CHARACTER_SET_RESULTS=utf8’); $rs = mysql_query($query_rsContent, $localhost) or die(mysql_error());

HowTo: Migrate / Move MySQL Database And Users To New Server

See this as well : Backup and Restore mysql database