From the category archives:

MySQL

Today, I got following MySQL error in a PHP application: Host ‘host_name’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’. It means that mysqld has received many connection requests from the given host. Default max_connect_errors value is 10, that is remote host will be blocked if there is more than 10 connection […]

{ 0 comments }

There’s a simple command to automatically check, repair and optimize all tables in all databases when you’re running a MySQL server on Linux / Unix / BSD. mysqlcheck -u{username} -p{password} –check –optimize –auto-repair –all-databases

{ 0 comments }

MySQL Slow Query Log File

by lifeLinux on May 8, 2011

The slow query log consists of all SQL statements that took more than long_query_time seconds to execute and required at least min_examined_row_limit rows to be examined. The time to acquire the initial table locks is not counted as execution time. mysqld writes a statement to the slow query log after it has been executed and […]

{ 0 comments }

If you have very large mysql database then it is very hard to backup and restore using the conventional phpmyadmin or any other programs. In this Tutorial I will explain you how to backup and restore a larger database. This tutorial can be used while moving your database from one server to another.

{ 0 comments }

Reset The Root Password Of MySQL Server

by lifeLinux on November 24, 2010

By default, MySQL server will be installed with root account and password is blank. If you have set the password for root and forget it, then you will need to reset the root password for MySQL.

{ 1 comment }

Converting to Per Table Data for InnoDB

by admin on November 23, 2010

Issue with shared InnoDB /var/lib/mysql/ibdata1 storage InnoDB tables currently store data and indexes into a shared tablespace (/var/lib/mysql/ibdata1). Due to the shared tablespace, data corruption for one InnoDB table can result in MySQL failing to start up on the entire machine. Repairing InnoDB corruption can be extremely difficult to perform and can result in data […]

{ 0 comments }