Mysql: How to repair all mysql tables in MySQL?
Nov 06
How to repair in MYSQL all tables ?
Just run in console
1 | mysqlcheck -u root -p --auto-repair --check --optimize --all-databases -p[password] |
Where password – this is admin password!
How to get all spam comets from Wordpress blog ?
Sep 25
Run this code from phpmyadmin
1 2 3 | SELECT * FROM `wp_comments` WHERE `comment_approved` LIKE 'spam' |
How to – MySQL tuning in debian.
Sep 24
Results of compiling this scripts was recommendations how to change mysql params.
note. For best result please run MYSQL before testing – 48 hours!
1 2 3 | wget http://mysqltuner.com/mysqltuner.pl chmod +x mysqltuner.pl ./mysqltuner.pl |
OR (also) try this script
1 2 | wget http://www.day32.com/MySQL/tuning-primer.sh sh tuning-primer.sh |
phpdug symbols encoding problem
Jul 25
phpdug coul not works normal with russian and other languages well in front and backed
to fix this you need just add
1 2 3 4 5 | mysql_query( "set session character_set_server=utf8;", $db_connection ); mysql_query( "set session character_set_database=utf8;", $db_connection ); mysql_query( "set session character_set_connection=utf8;", $db_connection ); mysql_query( "set session character_set_results=utf8;", $db_connection ); mysql_query( "set session character_set_client=utf8;", $db_connection ); |
to
line 81
1 2 3 4 5 6 7 8 9 10 11 | function db_connect($config) { $db_connection = @mysql_connect ($config['db']['host'], $config['db']['user'], $config['db']['pass']) OR error (mysql_error(),$config, __LINE__, __FILE__, 0, ''); $db_select = @mysql_select_db ($config['db']['name']) or error (mysql_error(),$config, __LINE__, __FILE__, 0, ''); mysql_query( "set session character_set_server=utf8;", $db_connection ); mysql_query( "set session character_set_database=utf8;", $db_connection ); mysql_query( "set session character_set_connection=utf8;", $db_connection ); mysql_query( "set session character_set_results=utf8;", $db_connection ); mysql_query( "set session character_set_client=utf8;", $db_connection ); return $db_connection; } |
public_html\includes\functions\func.global.php