Useful for /etc/my.cnf tunning of mysql
https://github.com/rackerhacker/MySQLTuner-perl
|
||||
|
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()); 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/ |
|
|||
