Month: July 2011

MySQL is one of the widely used database software in the application world. Many times, one has to work on the MySQL services and restart the services for the changes made to take effect or etc...

While restarting MySQL service, you may get a error as

MySQL is running but PID file could not be found

This might be due to issues with disk space, disk inode usage or innodb corruption which may lead to the error.

In my case, the issue was with the pid file and solution was:

1) SSH server as a root user

2) Create directory /var/run/mysql

mkdir /var/run/mysql

3) Create  a file with name as mysqld.pid

touch mysqld.pid

4) Change its ownership and group to  mysql:mysql

chown mysql:mysql mysqld.pid

5) Restart MySQL service and you will see no more errors

If any feedback, queries are always welcome!

If you are using cPanel and Linux server, you may face error while restarting named / bind service after making changes in the zone file

nameserver: reload skipped on server (nameserver disabled) 

while saving changes in zonw filw from WHM

OR

Bind reloading on server1 using rndc zone: [ensermo.com]
Bind reloading on server2 using rndc zone: [ensermo.com]
Bind reload skipped on newserver(nameserver disabled)

while restarting bind/named service from shell.

Read More »

If  you are using Plesk and MySQL you may get a error while adding a MySQL database user to a database as

Error: Connection to the database server has failed:

Table ‘mysql.servers’ doesn’t exist

• To fix this error, SSH  the server as a root user.

• Execute the command

[root@server ~]# mysql_fix_privilege_tables --user=admin --password=<admin password> --verbose

• On executing the above command, you should see following output

Read More »

If you are getting Mysql Error: #42000

Import error: The used command is not allowed with this MySQL version

Such type of error generally occurs when you are trying to import data from a file into MySQL using LOAD DATA LOCAL INFILE.

To solve this problem, you will have to make changes in the my.cnf file on the server. It is generally located at /etc in Linux.

• Open the my.cnf in any editor like VIM editor

# vi /etc/my.cnf

• Read More »

Server optimization always include MYSQL optimization which plays an important role in the overall performance of the server. Optimization of my.cnf file which is located at /etc/my.cnf is very important to ensure good performance of MYSQL .

I am putting forward a optimized my.cnf for a 2GHZ processor and 1GB RAM.

Kindly do not copy and paste the codes blindly. Check the server configuration and optimize my.cnf file accordingly.

# cat /etc/my.cnf

[mysqld]
socket=/path/to/mysql.sock
datadir=/var/lib/mysql
skip-locking
skip-innodb
# No community software I am aware of actually needs LOAD DATA LOCAL,
# so I just disable it. See:
# http://dev.mysql.com/doc/refman/5.1/en/load-data-local.html
local-infile= 0
# MySQL 4.x has query caching available.

Read More »