$ mysqldump –default-character-set=latin1 –databases wordpress > m.sql
$ replace “CHARSET=latin1″ “CHARSET=utf8″ \
“SET NAMES latin1″ “SET NAMES utf8″ < m.sql > m2.sql
$ mysql < m2.sql
wp-config.php:
define(‘DB_CHARSET’, ‘utf8′);
define(‘DB_COLLATE’, ”);
atppp’s Blog » Convert WordPress database from Latin1 to UTF-8
max_connections = 500
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 256M
key_buffer_size=512M
table_cache=2048
sort_buffer_size=32M
read_buffer_size=16M
http://www.profitpapers.com/papers/performance-tuning-mysql-for-load.php
http://www.professionalmiddleman.com/blog/2007/10/mysql-table-is-.html
http://rackerhacker.com/mysqltuner/
you’ll want to change this line in /etc/my.cnf from:
innodb_data_file_path = ibdata1:10M:autoextend:max:128M
to
innodb_data_file_path = ibdata1:10M:autoextend
Professional Middleman: MySQL table is full error on Gentoo Linux
Theme Null
plugins:
[I] x11-plugins/gkrellm-hddtemp
[I] x11-plugins/gkrellm-leds
[I] x11-plugins/gkrellm-radio
[I] x11-plugins/gkrellm-volume
[I] x11-plugins/gkrellmss
[I] x11-plugins/gkrellm-multiping
[I] x11-plugins/gkrellm-shot
[I] x11-plugins/gkrellm-top
see
functions.inc.php file. Note the two “/2″ additions.
Change:
// set max string size before writing to file
if (@ini_get(“memory_limit”)) $max_size=900000*ini_get(“memory_limit”);
else $max_size=$PMBP_SYS_VAR['memory_limit'];
To:
// set max string size before writing to file
if (@ini_get(“memory_limit”)) $max_size=900000*ini_get(“memory_limit”)/2;
else $max_size=$PMBP_SYS_VAR['memory_limit']/2;
SourceForge.net: Detail: 1774361 – Memory Exhasted Bug Fix Suggestion
+
PHP Fatal error: Maximum execution time of 60 seconds exceeded in {phpMyBackupPro}\functions.inc.php [ phpMyBackupPro v2.1]
Solution: To increase the execution time of PHP, You can modify the {phpMyBackupPro}\global_conf.php
Original code
$CONF['timelimit']=”60″;
Modified code
$CONF['timelimit']=”600″;
http://errerrors.blogspot.com/2007/09/php-fatal-error-maximum-execution-time.html
mysql>reset master;
you can set the binary log file limit in my cnf:
[mysqld]
max_binlog_size = 500M
