Travel

Categories

mysqltunner script

Useful for /etc/my.cnf tunning of mysql

https://github.com/rackerhacker/MySQLTuner-perl

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

http://www.cyberciti.biz/tips/move-mysql-users-privileges-grants-from-one-host-to-new-host.html

See this as well : Backup and Restore mysql database

http://www.mydigitallife.info/2007/07/21/how-to-backup-and-restore-export-and-import-mysql-databases-tutorial/