Useful Mysql Commands
November 6th, 2009 Filed Under General, Mysql
Gentoo Blog » Useful Mysql Commands
Post Linx
Permalink | Trackback |
|
Print This Article | Leave a Comment
iRedMail: Build A Full-Featured Mail Server With LDAP, Postfix, RoundCube, Dovecot, ClamAV, DKIM, SPF On CentOS 5.x
April 15th, 2009 Filed Under General, Mail, Mysql, Scripts
Post Linx
Permalink | Trackback |
|
Print This Article | Leave a Comment
Convert WordPress database from Latin1 to UTF-8
June 30th, 2008 Filed Under Mysql, Wordpress
$ 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
Post Linx
Permalink | Trackback |
|
Print This Article | Leave a Comment
MySQL tunning
June 30th, 2008 Filed Under Mysql
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/
Post Linx
Permalink | Trackback |
|
Print This Article | Leave a Comment
MySQL table is full error
June 30th, 2008 Filed Under Gentoo, Mysql
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
Post Linx
Permalink | Trackback |
|
Print This Article | Leave a Comment
Recover a MySQL Table with Zmanda Recovery Manager
May 13th, 2008 Filed Under General, Mysql
Recover a MySQL Table with Zmanda Recovery Manager | Linux Journal
Post Linx
Permalink | Trackback |
|
Print This Article | Leave a Comment
Gkrellm
April 30th, 2008 Filed Under Cool Apps, General, Gentoo, Mysql, X11
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
Post Linx
Permalink | Trackback |
|
Print This Article | Leave a Comment
phpMyBackupPro bug
April 8th, 2008 Filed Under Apache, General, Mysql
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
Post Linx
Permalink | Trackback |
|
Print This Article | Leave a Comment
Mysql clean bin logs
April 3rd, 2008 Filed Under Mysql
mysql>reset master;
you can set the binary log file limit in my cnf:
[mysqld]
max_binlog_size = 500M
http://free.netartmedia.net/Databases/Databases5.html
Post Linx
Permalink | Trackback |
|
Print This Article | Leave a Comment