ServerBuddies Support Blog

How to change the storage engine to InnoDB

1.Edit the /etc/my.cnf file and look for this line:

and comment it out:

2.Add the following entry in the /etc/my.cnf file

3. Save the file, and restart mysql

4. You can use the following command to check the “storage engine” used in the server.

You will see the storage engine as “InnoDB”.

Reseller list missing in WHM

This article discusses how to resolve issues where the WHM reseller list has disappeared however they still exist in Apache’s configuration and the users’ directories still exist in /home
Resolutions

1)/var/cpanel/users/

/var/cpanel/users/username should have the following syntax per line “DNS=domain.com” line. If not, edit this file and change the line to DNS=domain.com

Secondly, be sure to check that the DNS zone above exists in “Edit DNS Zone” in WHM. If not, add it via “Add DNS Zone” in WHM.

2)/etc/httpd/conf/httpd.conf

Double check that there is a VirtualHost container per domain in /var/named/

3)/etc/userdomains

/etc/userdomains should have the following syntax per line “domain.com: user” where user is the reseller. If not, edit this file and change the file to match.

4)/etc/trueuserdomains

/etc/trueuserdomains should also have the following syntax per line “domain.com:user”where user is the domain owner user. If not:

MySQL service is failing to start up with error “Can’t init databases”

Following is the error message in mysql server log file /var/log/mysqld.log:

While trying to start it, following is the error.

Initializing MySQL database: [ OK ]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

This error occurs when MySQL is not able to access the /tmp directory to write and create temporary files. Make sure /tmp is owned by root and 1777 permisssion is set on /tmp directory.

Following commands will fix the problem.

Now MySQL should start without a problem.

Timeout error occurred when trying to start MySQL Daemon.

If you are getting the following error while trying to start MySQL service;

And if you are getting the following error in the MySQL log;

The issue might be due to the lack of space in the ‘/var’ partition. So you need to reduce the disk space, which should fix the issue.

Using the above commands, you can see that files and folders which consumes more size. You need to delete the unwanted files or folders and try reduce the size.

Try restart the MySQL service.

Steps to change the mysql database directory in Linux server

Some times the ‘/var’ partition get crowded and we might need to relocate the database to some other location where there is enough space. Below are the steps given for a trouble free relocation.

Note: Let ‘/mysql’ be the directory to which we want to relocate the database.

Steps to change the mysql database directory:

1. Execute the following command in the server to write the transactions saved in the memory to the hard disk.

2. Stop the mysql process in the server.

3. Move the database files to the the new directory.

4. Create symlink with the old directory.

5. Give the correct ownership to the new directory.

6. Restart mysql in the server.